Noob: Help with form label names

[poet_will]

I am creating a form utilizing all of the fields of my table (table1). I want the form label names to be from the description of the fields from table1. I have over 50 fields and was wondering if I could do this automatically.

Example:

table1
Field: Description:
Policy_Date Date policy began

Form
Label: Text Box:
Date policy began Policy_Date

Any help would be appreciated.

 

[jeremie_ingram]

If I am understanding the question correctly, you want the DESCRIPTIONS of the fileds to appear as the FORM LABELS when they are placed on a form.

If so, then you need to ensure that the CAPTIONS property for the fields in the TABLE are set to the DESCRIPTIONS.

Open the table in design view, and click in the CAPTIONS field in the bottom area of the window (for one of the fields you want this to work on). Look to the left gray area as it will produce the description for what that filed does. I think this is what you are attempting.

 

[poet_will]

Ya, that is what I'm looking for. However, when I go to the CAPTION property for the field it does not give me an option to choose DESCRIPTION. It seems to me that I would have to type it all in again (which I'm trying to get around doing). Can I just type DESCRIPTION and it work? I'm using Access 2000.

Thanks for the help

 

[jeremie_ingram]

To the best of my knowledge, no. But dont give up hope. You may post in the VBA section to see if someone knows how to access that attribute and display it in a lable, but I doubt it.

 

[poet_will]

Ok, thanks for all your help. I guess i could just copy/paste it all into the caption.