Recognising the user switch between Form view and Data sheet view

  • Thread starter Thread starter Mike Turner
  • Start date Start date
M

Mike Turner

My Uncle has an Access application where he would like to sometimes switch
from a Form's Form View to Data sheet view and back. He would like certain
settings for each view (eg form maximisable when in Data Sheet view but not
when in Form view,and certain fields hidden in data sheet view but visible in
text boxes in Form view. So,is there an event which is fired when the form's
view style is being changed,so that I could put appropriate coding there?
Either Access 2003 or 2007 could be used,preferably 2003.

I realize I could put a button on the form in form view, say,where I could
put code that handled any changes needed from Form view to Datasheet view but
it seems it would not be there when moving back form Data sheet view to Form
view!

Any suggestions welcome.Many thanks
 
I would question the design here. Generally datasheet view (and continuous
form view) are used to display multiple records in a sheet like format a bit
like a spreadsheet. To view further details for a specific record you would
normally open a different more detailed form in Single Form view.

So use two different forms here rather than try to modify one form according
to its View.

Alternatively, if you must use the same form then why dont you use
Continuous Forms view instead of Datasheet view. That way you can have a
button on each of the records to change to single form view with the coded
changes you need.

HTH
 
Mike Turner said:
My Uncle has an Access application where he would like to sometimes switch
from a Form's Form View to Data sheet view and back. He would like certain
settings for each view (eg form maximisable when in Data Sheet view but
not
when in Form view,and certain fields hidden in data sheet view but visible
in
text boxes in Form view. So,is there an event which is fired when the
form's
view style is being changed,so that I could put appropriate coding there?
Either Access 2003 or 2007 could be used,preferably 2003.

I realize I could put a button on the form in form view, say,where I could
put code that handled any changes needed from Form view to Datasheet view
but
it seems it would not be there when moving back form Data sheet view to
Form
view!
Click to expand...

I've done something like that to change the mode of a subform using a button
on the main form. That way the button is always available, even when the
subform has been switched to datasheet mode. If you're working with a single
main form, you could make that form a subform of an unbound main form that
just has the mode switch button.

You might be able to do something with a custom right-click context menu for
the form, but I haven't tried it.
 
Jon, BruceM and Paul: Many thanks for your answers. I will now experiment
with your ideas.
 
Back
Top