add a colon

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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...
 
Back
Top