add caption

[blue3509]

any one know the proper way to add caption to a field name? the field name
is Employee Name


the question ask type in the field Employee Name than add the caption
last name , first name. any one know how to add the caption ?

 

[Jeff Boyce]

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[blue3509]

your missing the point i know use the caption property... i just dont know
what to put in the caption. i am not sure just typing last name first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

 

[Jeff Boyce]

The caption property holds the literal string of what you want for ... the
caption.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

your missing the point i know use the caption property... i just dont know
what to put in the caption. i am not sure just typing last name first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

Gee, Jeff,
I guess you should have paid more attention in grade school.
You would have known Access by now.

 

[blue3509]

i need examples... of what your talking about i have no idea what you mean
by literal string........

 

[George Nicholson]

Per Help (rephrased a little):
"...Field captions specify 1) the text for labels that will be attached to
controls created by dragging a field from the field list while designing
forms and 2) serves as the column heading for the field in either table or
query Datasheet view..."

The Caption property is Optional. *IF* there is one, the Caption value will
appear in place of the field name as stated above. If there is no caption
the Field name will appear.

Why?
Examples: a lot of developers don't like spaces in field names, or they like
to preface the name with characters that tell them what type of field it is,
or use abbreviations in field names, etc.

Therefore, field names like:

EmployeeName
sngHourlyRate
SSN
fldNotes

Valid field names from a developer's point of view, but they are candidates
for "user friendly" captions like:

Employee Name
Hourly Rate
Social Security Number
Notes and Comments

The "user friendly" captions appear in place of the "developer friendly"
field names in the situations stated above.

 

[John W. Vinson]

i need examples... of what your talking about i have no idea what you mean
by literal string........

Open the table in design view.
Select the field.
Look at the lower left of the screen.
If you type

This Is My Caption

in the Caption property of the field then you will see

This Is My Caption

as the caption of the field.

Insulting people who are trying to help you, and obviously asking to be
spoonfed answers so that you can avoid thinking or studying, is just going to
get you killfiled by the volunteers here. I'm of two minds whether to send
this... but be assured it's the first AND LAST time I'll spoon feed you.

 

[Jeff Boyce]

My pappy taught me not to get into a ... contest with a ...

Jeff <G!>