Form for Query not showing Captions of Table

[316854]

How do I get a form for a query of a table to show the captions that are in the table instead of the field names?

Thanks

[June7]

Properties like the caption of fields in table are adopted by controls when the field is added to form or report from the form/report designer Field List. Otherwise, will have to manually type whatever you want in the label.

[316854]

The labels are correct. I want the field headers of the form to show the captions in datasheet view, just like the table does.

Thanks

[Missinglinq]

...I want the field headers of the form to show the captions in datasheet view, just like the table does...

In Table Design View

1. Select a Field
2. Go down to the Caption Property, on the General Tab, for that Field
3. Enter the text you want to display (without Quotes)
4. Repeat for each Field

Note that this will not be reflected in existing Forms...only in Forms created after the Captions were entered.

The Labels 'being correct' doesn't really come into it, in a Datasheet View Form; Labels aren't displayed in this type of Form View.

Linq ;0)>

[June7]

The datasheet view should take as headers the caption of label associated with the textbox or combobox. If the data control does not have associated label, then the fieldname will be the header. That's what happens in my db.

[316854]

How do I associate a label with a combobox?

[June7]

A newly created data control should have an associated label. If there are disassociated labels and they no longer show little green triangle in upper left corner, delete label then paste back and the triangle will show (or create new label from the controls collection). Click on triangle and make choices to associate label.