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

combo box name property in datasheet view issue

P: n/a
I want to follow naming conventions for my controls - i usually prefix combo
boxes with "cbo". When a form is in datasheet view however i do not want
the user to see the 'cbo' prefix in front of the field name.

Is there a way to retain this nomenclature and yet have the view display the
field name (or anyname i want for that matter)?

Thanks

--
kent eilers
ke**@kaeServices.com
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When you set up the Datasheet - don't use the datasheet form wizard -
use the Columnar form wizard, then edit the design of the form. This
will give you the control names with their labels. Change the form to
a datasheet form, using the form's Default View property. When the
datasheet displays it will use the controls' label names as the column
names.

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP84iEYechKqOuFEgEQK2FgCdFIU9IEEYwumDAJrzARqCw1 b+9UYAniiq
fDmsW/LLYLXQf1K0jNrNWLXV
=O+wn
-----END PGP SIGNATURE-----

Kent Eilers wrote:
I want to follow naming conventions for my controls - i usually prefix combo
boxes with "cbo". When a form is in datasheet view however i do not want
the user to see the 'cbo' prefix in front of the field name.

Is there a way to retain this nomenclature and yet have the view display the
field name (or anyname i want for that matter)?

Thanks


Nov 12 '05 #2

P: n/a
what label? there is no label property on the property sheet. Look up
combo box in the object viewer and look for the label property. It is not
there. I can't find any 'label' equivalent property for combo boxes. Or
caption. Or anything that suggests changing the column header name for this
control when it is in sheetview mode.

I did not use a wizard to create this combo box.

Sorry for the frustration. ((

"MGFoster" <me@privacy.com> wrote in message
news:nm*******************@newsread1.news.pas.eart hlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When you set up the Datasheet - don't use the datasheet form wizard -
use the Columnar form wizard, then edit the design of the form. This
will give you the control names with their labels. Change the form to
a datasheet form, using the form's Default View property. When the
datasheet displays it will use the controls' label names as the column
names.

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP84iEYechKqOuFEgEQK2FgCdFIU9IEEYwumDAJrzARqCw1 b+9UYAniiq
fDmsW/LLYLXQf1K0jNrNWLXV
=O+wn
-----END PGP SIGNATURE-----

Kent Eilers wrote:
I want to follow naming conventions for my controls - i usually prefix combo boxes with "cbo". When a form is in datasheet view however i do not want the user to see the 'cbo' prefix in front of the field name.

Is there a way to retain this nomenclature and yet have the view display the field name (or anyname i want for that matter)?

Thanks

Nov 12 '05 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

S'OK... Try this demonstration:

Open a new form in design view. Select a combo box control from the
controls toolbar and place it in the Details section of the form.
When the control appears on the form it will have a ComboBox control
and to its left (usually) the ComboBox Label. Type a new Caption into
the ComboBox Label. Open the form in Datasheet view. You will see
the ComboBox column with the ComboBox's Label's Caption as the
datasheet column name.

If you don't get a Label when you create the ComboBox then your
Default Form has been changed. Not to worry - select a Label control
in the Controls Toolbar and place it on the form (anywhere). Then
click on the Label (Set Focus) and hit Ctrl-X (cut). This will cut
the Label control to the Clipboard. Click on the ComboBox (Set Focus)
and hit Ctrl-V (paste). This will attach the Label to the ComboBox.
Remember this is Access VBA, not VB. In VB Labels are not attached to
controls.

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP891wYechKqOuFEgEQJY+QCfZYW2yYaSuNiDudk0/tc32gjxoEQAnio+
SmkSHu61lSYoUAvg1+sdX9Ae
=uzOa
-----END PGP SIGNATURE-----

Kent Eilers wrote:
what label? there is no label property on the property sheet. Look up
combo box in the object viewer and look for the label property. It is not
there. I can't find any 'label' equivalent property for combo boxes. Or
caption. Or anything that suggests changing the column header name for this
control when it is in sheetview mode.

I did not use a wizard to create this combo box.

Sorry for the frustration. ((

"MGFoster" <me@privacy.com> wrote in message
news:nm*******************@newsread1.news.pas.eart hlink.net...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When you set up the Datasheet - don't use the datasheet form wizard -
use the Columnar form wizard, then edit the design of the form. This
will give you the control names with their labels. Change the form to
a datasheet form, using the form's Default View property. When the
datasheet displays it will use the controls' label names as the column
names.

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP84iEYechKqOuFEgEQK2FgCdFIU9IEEYwumDAJrzARqCw1 b+9UYAniiq
fDmsW/LLYLXQf1K0jNrNWLXV
=O+wn
-----END PGP SIGNATURE-----

Kent Eilers wrote:
I want to follow naming conventions for my controls - i usually prefix
combo
boxes with "cbo". When a form is in datasheet view however i do not
want
the user to see the 'cbo' prefix in front of the field name.

Is there a way to retain this nomenclature and yet have the view display
the
field name (or anyname i want for that matter)?

Thanks



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.