combo box name property in datasheet view issue

[Kent Eilers]

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

[MGFoster]

-----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

[Kent Eilers]

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" <[e-mail]> 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

[MGFoster]

-----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" <[e-mail]> 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