="Blah and " & field, etc.

[Dannybe2]

How do I create a field which fills in other information not in that field. For example, I have a field which has a number of hours, and I want to add the word "hours" after it, whenever I try it as follows it comes up with a #error in the field:

=[TimeHours] & " Hours"

Thanks

 

[pdldavis]

Hi, =[TimeHours] & " Hours" looks correct. If you are getting an error, [TimeHours] may be misspelled. A way to check that would be to set the control source to TimeHours. If that comes in correctly, then your statement should work.

 

[DonQuichote]

I have two options for you:

- use the format property of the text box

- use another textbox and make the original textbox hidden. I have to explain this one. If your textbox is called TimeHours, than [TimeHours] is probably calling the textbox itself, not the field in the underlying query or table. So making the textbox TimeHours invisible and using your phrase (=[TimeHours] & " Hours&quot in another (visible) textbox may solve your problem.

Hope this helps or amuses,

Willem Bogaerts