Datasheet view form without application title bar

[ScottXe]

Is there any possibility to have the application title bar on data sheet view form? I need it to close the form and return to main switchboard using the Close button. Your guidance is appreciated. Thanks!

 

[JHB]

I don't get it, can you explain in other words, what you want, (because the Thread title confuse me!)?

 

[ScottXe]

This photo shows data sheet view without application title bar

/Volumes/SanDisk64GB/2014-08-21 21.34.53.png


This photo shows tabular view with application title

bar/Volumes/SanDisk64GB/2014-08-21 21.36.49.png

 

[ScottXe]

I tried to show you with screen captures without success.

 

[ScottXe]

I have located why the application title bar disappears. It is due to open form to maximise. Once I removed it, the application title bar appears. However, if the user clicks the maximise button to turn the form to maximum, the title bar disappears again. Is there any way to key to restore the form?

 

[JHB]

Have you set the "Application Title" under "Access Options"?

 

[ScottXe]

The screen capture (2014-08-21 21.36.49.png) is the said title bar (2nd one from the top) and the title bar disappeared when the form is opened to maximum. Is there any key short-cut to restore down the form showing the title bar again?

 

[vbaInet]

If the form is set as a Pop Up form show the Caption of the form.

 

[ScottXe]

I tried to set PopUp to yes but no avail - the title bar still disappear at max form.

I believe two possible solutions:-

Disable the maximise button

Use keyboard shortcut to restore down the form - I have not found the shortcut so far.

 

[vbaInet]

Sorry, what I wrote didn't make sense. What I was saying was that I thought that your form was set as a pop up already which is causing the application title from showing up.

Upload a test db so we can see what you're talking about.

 

[ScottXe]

Thanks for all who responded. I have fixed this shortfall in maximise form of Access by adding a close form command button in header section of the form.