User Defined Form Labels

[TKnight]

Hi, I'm currently writing a db that i'm hoping to turn into an actual app later on. I have about 5 fields that I want the user to name when they first run the db.
Firstly I have no idea how to do this (if it's possible) and secondly if i change the name's of the fields in the tables then all the queries/reports/VB that i've written concerning those fields will not work anymore.
I've thought about keeping the field names the same for mechanical purposes and just having the user defined fields as labels for forms etc. but that still won't change query headings etc. so it's really not a viable option.
Can anyone point me in the right direction? Thanks, Tom.

 

[FoFa]

To do this takes a little work. Even more if it is a shared DB. You have to be able to store a users preference in a table to access. For form you just need to set the caption of the label, you can do this in VBA in the load event. Queries you have to either change the column name in the current querydef or create a querydef on the fly (either way use vba). Reports, I have seen it done, but I have not done it, maybe there is an expert in reports that can help with that.