Can the bar at the bottom of any query be set to stay at a certain hight?
Can the bar at the bottom of any query be set to stay at a certain hight?
Do you mean in Datasheet view? Is database set for Overlapping Windows?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
No, in Design view. Sorry I don't know about setting database for overlapping Windows. As you know we open queries thousands of times and most of the time I have to move that bar out of the way, it doesn't stay where it was when it was saved.
I don't use Tabbed Documents. I always set for Overlapping Windows in Database Options. I am not sure what you mean by 'bar' and moving.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
If you position the bar where you want it for a query then Save while still in Design, next time you open that query in Design, bar should be in same position. Although, if db is set for OverlappingWindows, the bar's position can be influenced by resizing query window in Datasheet. In either mode, resizing the Access app window can cause the bar's position to appear to change although it hasn't really.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.