Customisable Field Labels

[CutAndPaste]

I have a requirement to allow users to custom "label" 10 fields. I've created a mini table where they can enter their Custom names for Field1 to Field10. I've then put unbound fields next to each of the Fields on my form and used DLookUp to reference the Custom Name of the Field1 and so on from the table. Just can't seem to get this to work.

Is this the correct approach? Would setting the caption be a better idea?, though it would still need to get it's values from the CustomFieldName table.. (I know there are often many ways to skin the cat in Access...)

Any ideas?

 

[Carol]

Put the following in the Control Source of each text box that you would like customed labelled:

=DLookUp("[Field1]","CustomFieldName")