Dear Richard,

There is something that i am failing to figure out how but i guess it is possible in Access. A customer from another country asked me to customise the database that i built to suit the needs of his own country. I have used the CurrentUserID to uniquely identify this user and display to him different fields that are relevant to his country. This works fine.

The challenges that i have now are the reports. Whenever this user logs in, i would like the label caption that reads "County", to read as "District". I could do this in the OnOpen event for each report but i guess it will be cumbersome for me. How could i loop hrough all the reports in the database, and if this particlar label exists on the report, the caption will read "District" and not "County" for this particualr user?

Should it be necessary, i will provide you with more explanations.

Thank you,

MICAH

---

Reply from Richard Rost:

I would create a table to store any custom labels like this, and then instead of a label, use a text box in your reports with a dlookup statement to pull in that value. Then you could add any kind of customization you want. I built a whole database this way once because my client wanted to translate every form and report into different languages.