By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,536 Members | 2,165 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,536 IT Pros & Developers. It's quick & easy.

Field Names in Datasheet View - A97

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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
Nov 12 '05 #2

P: n/a
"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.
Nov 12 '05 #3

P: n/a
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.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.