Field Names in Datasheet View - A97

[Keith Wilby]

I have a form which allows both form and datasheet views. My question is,
is it possible to control the field (column) names in datasheet view? What
happens at the moment is that the name is taken from a control's label if
there is one, and if not, the control's name is used.

This is confusing for my users so I'd like to be able to use more sensible
names in datasheet view. Is this possible?

Many thanks.
Keith.

[Fletcher Arnold]

"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn************************@10.15.188.42...

I have a form which allows both form and datasheet views. My question is,
is it possible to control the field (column) names in datasheet view? What happens at the moment is that the name is taken from a control's label if
there is one, and if not, the control's name is used.

This is confusing for my users so I'd like to be able to use more sensible
names in datasheet view. Is this possible?

Many thanks.
Keith.

Hi Keith
I almost always use labels if the form is to be viewed as a datasheet - not
only does the label caption appear as the column header, but also appears
when you use the standard search. This is pretty important if you have
geeky field names. Don't forget that this still works if the label is made
invisible - a trick which might help in your case.
Of course the other route might be to put in a bit more work and have
frmDetails (allow form view only) and frmList (main form in form view only)
+ frmListSub (subform in datasheet view) combination. Buttons on frmDetails
and frmList can toggle between the 2 modes and although it's more work, it
also allows you more control - my forms generally open in one mode only.

Fletcher

[Keith Wilby]

"Fletcher Arnold" <fl****@home.com> wrote:

Don't forget that this still works if the label is made
invisible - a trick which might help in your case.

Thanks Fletcher, it's so bloomin' obvious now that you've mentioned it.

Thanks again,
Keith.

[rkc]

"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn************************@10.15.188.42...

I have a form which allows both form and datasheet views. My question is,
is it possible to control the field (column) names in datasheet view? What happens at the moment is that the name is taken from a control's label if
there is one, and if not, the control's name is used.

This is confusing for my users so I'd like to be able to use more sensible
names in datasheet view. Is this possible?

You can set a Caption for the field in table design view. Same tab at the
bottom where you can set it up as a lookup field.