Specify a different display name for a field (column) in Datasheet view

1. Open the table in Design view.
   
   
2. In the upper portion of the window, click the field for which you want to define a different column name.
   
   
3. In the lower portion of the window on the General tab, click the Caption property box, and then type the text for the column name. The text can contain any combination of letters, numbers, spaces, and symbols up to 255 characters in length.

Notes

• This is useful in situations where you want the column heading to be longer or more descriptive than the actual field name. For example, you might want to name a field LName for use in Visual Basic for Applications code and expressions, but display "Last Name" as the field's column heading.
  
  
• A field's Caption property also specifies the default text for labels attached to controls in forms and reports created with a wizard or by dragging a field from the field list.
  
  
• If you set a field's Caption property, and later rename that field while in Datasheet view, the field's caption text will be deleted. If this happens, you can redefine the field's caption as described in this topic. You can avoid this by renaming the field in Design view.