I have a text box in a form with the following control source:

=Format([Rotating Equipment Count]*[Enter # of Months in Period]/([Unit Count]*12),"0.0000")

The "Enter # of Months in Period" should be a user prompt, and used to work. Now it does not prompt, and the result in the box is #Name.

Anybody know what happened?

Thanks for you help.

This should generate an error, telling you that it can't find field "Enter # of Months in Period". you've enclosed it in braces, accordingly Access thinks that it's a field.

Use the InputBox function to prompt for variable in VBA. the braces are u8sed for prompts in queries.

I got it - I had to remove the Format command and just use the text box properties to set the format.

Thanks for your help