add a colon

[Guest]

Any idea why Access adds a colon to a field name? I have a field in a table
called "No" (for number) and when I added that field to a form, a colon
showed up: "No:". My only concern is if it will still be there when I export
data.

Thanks!
Christine

 

[tina]

where is the colon showing up? in the ControlSource property of the control
on the form? or in the Caption property of the control's label?

hth

 

[Al Camp]

Christine,
The "No:" is just the "Label" for your TextControl, so it doesn't get stored. The
TextControl itself, when bound to a field in your table, will store whatever is entered
there.

The auto insertion of a colon on labels acts as a visual sperator between the label and
the field... particularly when the field value is Left aligned...
YourLabelYourFieldValue
YourLabel:YourFieldValue

 

[Guest]

Thank you!

Christine,
The "No:" is just the "Label" for your TextControl, so it doesn't get stored. The
TextControl itself, when bound to a field in your table, will store whatever is entered
there.

The auto insertion of a colon on labels acts as a visual sperator between the label and
the field... particularly when the field value is Left aligned...
YourLabelYourFieldValue
YourLabel:YourFieldValue
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions