Datasheet subform

Topic

New Reply

I’m having a devil of a time with Access 2007. I’m trying to insert a datasheet view subform into a form, and It just doesn’t work. I created the datasheet form, but upon dragging it onto my main form it changes the format from datasheet to tabular (or something similar).

Another bothersome change from previous Access versions is that when adding a field to a form I cannot delete the field name separate from the field itself. If I try to delete the field name it also deletes the field. What am I missing here?

Reply | Quote

Replies

Hi Chuck,

I’m not having the same issue dragging the DS onto another form, I guess you’ve set the default view to ‘datasheet’ and that’s the only thing I can see that determines how it displays. There is no subform property that changes its behaviour.

As for the second, you can still create DS forms the old way using Create>From Design. The method you used here where you selected Create>More Forms> Datasheet creates a form where the controls act differently.

The labels are part of the control and determine the column header (no difference there) but you can’t delete them. All the controls are the same width and evenly spaced but here is the ‘useful’ bit – you can drag a control up or down and Access automatically rearranges all the other controls so it fits nicely and they are all equally spaced. This also changest the order of the columns in the DS view.

So you can still use the old way but once you get used to then new DS you will find it quite nice.

One thing that still annoys me is that setting the controls visible property to false doesn’t stop it showing in DS view. You need to set its ColumnHidden property in the open event.

Reply | Quote

I discovered Ihad to turn off the Layout feature before 2007 acts like the older versions. I sometimes get very frustrated with Access’s attemps to “help” me. Many of these built-in feature are more hinderance than help. I recall the Main Menu feature which I found terribly complicated and confusing whereas a little VB coding on my part would result in a very simple, straightforward main menu.

Reply | Quote

I sometimes get very frustrated with Access’s attemps to “help” me.
Many of these built-in feature are more hinderance than help.

Very True.

Reply | Quote