How can I create a calculation field with the same name as the database. Only showing the name of the database, not all the databases that are open.

Many Thanks

Steve

Hi Steve, you want the name of the field to be the same as the database name, or the contents?

If it's the latter, Get ( FileName ) will work nicely.

Jerry

Thanks Jerry

Do you know why the name is not re-calculated when the file is saved as a different name?

I thought the fact it is a calculation would have overcome this.

Thanks

Steve

Change the field calculation to be unstored (found in storage options in the calculation definition).

Chuck

Thanks Chuck

You hit the nail on the head

Cheers

Steve