add a colon

R

Rabbit

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
 
T

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
 
A

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
 
R

Rabbit

Thank you!

Al Camp said:
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
Click to expand...
 
Top