Table minimised in query builder

[George-Bowyer]

One of my tables has "disappeared" in the query builder.

You can see the link going to the table and you can see the yellow highlight of the table being selected, but it seems to be reduced in width to zero, so I can't grab it to move it out to the right.

Anyone got any suggestions, please? I'd rather not have to rewrite the entire query...

Thanks

 

[Gasman]

Minimize the navigation wndow?

 

[George-Bowyer]

Minimize the navigation wndow?

I'm not quite sure what you mean?

 

[oleronesoftwares]

Close the navigation window, i.e click the << and maximize the query design view.

 

[Gasman]

Close the navigation window, i.e click the << and maximize the query design view.

No, I just tried that. Makes no difference.

 

[Gasman]

As it is a query.
Switch to SQL view and copy the code.
Open a new query window and paste in SQL view, now switch to Design view. rearrange as needed.
Save it, delete the old one and rename new to old name.

 

[George-Bowyer]

Thanks, Gasman.

That worked as a workaround the problem. The new query had the right layout.

Out of interest, however, I'd still like to know how to solve the original problem.

(And how it happened - I didn't do it...)

Thanks,

George

 

[Gasman]

TBH I do not know. I first tested it with the DB relationships, and when I moved a table off to the left as you have it, could not get it back?
Fortunately for you, yours was a query relationship.

 

[CJ_London]

there is a 'bug' of sorts.. If you reduce the width of the table as much as possible, regardless of where it is in the GUI window, it would appear that you cannot then widen it again from the right hand side, you have to use the left hand side assuming it is visible and has enough space to drag it left. In 2010 if join lines are coming in from the right, they get left behind once the width is narrow enough

 

[oleronesoftwares]

Thanks, Gasman.

That worked as a workaround the problem. The new query had the right layout.

Out of interest, however, I'd still like to know how to solve the original problem.

(And how it happened - I didn't do it...)

Thanks,

Did you try my suggestion?

 

[Gasman]

Did you try my suggestion?

I said that did not work in post #5
I tried that initially and was my original thought at first.

 

[oleronesoftwares]

I said that did not work in post #5
I tried that initially and was my original thought at first.

Ok, cause it worked for me.

 

[Gasman]

Ok, cause it worked for me.

Worth a try for the O/P then?