Set Default Form Mode to Continuous?

  • Thread starter Thread starter steph
  • Start date Start date
S

steph

Hi,

I' have this form where the default view is datasheet. However, users
should be able to change to a continuous-form view.

When I set the default view to continuous-form, then it's no problem to
switch between datasheet and continuous-form. But when I set the
default view to datasheet, I only can switch to single-form mode, not
to contiuous-form mode.

Can this behaviour be changed, so that default view is datasheet, but I
still can change to continuous form? What would be the corresponding
properties I have to set?

I'm using Microsoft Access 2002, SP3.

br,
Stephan
 
Hi,

I' have this form where the default view is datasheet. However, users
should be able to change to a continuous-form view.

When I set the default view to continuous-form, then it's no problem to
switch between datasheet and continuous-form. But when I set the
default view to datasheet, I only can switch to single-form mode, not
to contiuous-form mode.

Can this behaviour be changed, so that default view is datasheet, but I
still can change to continuous form? What would be the corresponding
properties I have to set?

I'm using Microsoft Access 2002, SP3.

br,
Stephan
Click to expand...

I don't believe there is any code to go from Datasheet to Continuous
View directly.
I would do it differently.
Leave the Default View as Continuous.
However, when you open the form, open it from a command button,
specifying Datasheet view:

DoCmd.OpenForm "FormName", acFormDS

The form will open in datasheet view.
Then, when you are ready, it's simply a matter of changing the view to
the default Continuous, either through the View ToolButton or code in
a control's double click event:
DoCmd.RunCommand acCmdFormView
 
That sounds like an option I could take. However, can I also set the
form-view programmatically in an event?
 
That sounds like an option I could take. However, can I also set the
form-view programmatically in an event?
Click to expand...

Did you not read this part of my reply?
Then, when you are ready, it's simply a matter of changing the view to
the default Continuous, either through the View ToolButton or code in
a control's double click event:
DoCmd.RunCommand acCmdFormView
Click to expand...

Note: Always include the relevant portion of the message you are
replying to. It makes it easier for someone to reply to whatever you
are replying to without having to go back and find the previous
message. It also makes it easier for someone reading this message
without the benefit of seeing the previous ones to understand it.
Thanks.
 
i have really overlooked your hint, i'm sorry

i have solved my problem now like this:
i've set my form's view to continuous. I have created a dummy form
which is called at startup. in the on-open event of this startup form
my main form is called in datasheet-view as you have proposed. then i
close the startup-form and thus focus goes to my main form. works fine
- thanks for your hints!

br,
stephan
 
Back
Top