A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form view



 
 
Thread Tools Display Modes
  #1  
Old March 21st, 2009, 05:56 AM posted to microsoft.public.access.tablesdbdesign
Bob76
external usenet poster
 
Posts: 38
Default Form view

I created a form called Master Employee List. Whenever I open this form, it
immediatedly opens in datasheet view. How can I have it open in Form View as
default?

Thanks, Bob
  #2  
Old March 21st, 2009, 06:56 AM posted to microsoft.public.access.tablesdbdesign
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Form view

Hi Bob76,
on the form's property dialog, on the format tab, look for the property
called Default View.
Change it to Single Form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Bob76" wrote in message
...
I created a form called Master Employee List. Whenever I open this form,
it
immediatedly opens in datasheet view. How can I have it open in Form View
as
default?

Thanks, Bob



  #3  
Old March 21st, 2009, 08:01 AM posted to microsoft.public.access.tablesdbdesign
Bob76
external usenet poster
 
Posts: 38
Default Form view

Did it.....Thanks a lot, Jeanette....

"Jeanette Cunningham" wrote:

Hi Bob76,
on the form's property dialog, on the format tab, look for the property
called Default View.
Change it to Single Form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Bob76" wrote in message
...
I created a form called Master Employee List. Whenever I open this form,
it
immediatedly opens in datasheet view. How can I have it open in Form View
as
default?

Thanks, Bob




  #4  
Old March 21st, 2009, 06:02 PM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default Form view

On Sat, 21 Mar 2009 00:01:01 -0700, Bob76 wrote:

Did it.....Thanks a lot, Jeanette....

"Jeanette Cunningham" wrote:

Hi Bob76,
on the form's property dialog, on the format tab, look for the property
called Default View.
Change it to Single Form.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Bob76" wrote in message
...
I created a form called Master Employee List. Whenever I open this form,
it
immediatedly opens in datasheet view. How can I have it open in Form View
as
default?

Thanks, Bob




Be aware that even though you have now set this form's Default View to
Datasheet View, if you should everr open it using code you must
specify Datasheet View, otherwise it will again open in Form View.

DoCmd.OpenForm "FormName", acFormDS

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.