How do add caption to a field name?

[blue3509]

I Have a problem adding caption to the field name Employee Name How do I
add the caption Last name , First Name?

I go down to field Properties where caption is and type last name, first
name but i am not sure if thats the correct way.

 

[KARL DEWEY]

Just us 'Last name' as field name. Or am I missing something?

 

[blue3509]

yes your missing something the field name is Employee name it said add a
caption last name first name to Employee name field...

 

[KARL DEWEY]

In your query in design view grid showing the fields type
Last name First name:
in front of field named Employee name and it will display the caption
instead of field name.

 

[John Spencer]

That should work to show a column name when you look at a query in Datasheet
view or when you show a form in datasheet view. Also, when you create a new
form and add controls from the table, the attached label will have the caption
you enter for the field in the table.

You should not have a field Employee Name that hold both the first and last
name of the employee. It will cause you problems when you run into a
requirement to show the name in First name Last Name form, or to show the
initial letter of the first name, or to show just the initials of the
individual, etc.

You almost always (there are always exceptions) split the name into at least
First and Last name fields. It is easy to combine the pieces, it is very
difficult to split the pieces.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County