Table field in label

[scheeps]

Is it possible to use a database field in a label? I know this is possible in a report (it is not a database field though, but you'll get the idea) e.g.

="Page " & [Page] & " of " & [Pages]

But it does not seem to work the same on a Form. I've got the following code in a label:

="Return Header Notes for " & [Return_Type_Name]

with [Return_Type_Name] as the field name.

Is this possible? If so, what do I miss.

 

[pbaldy]

You can use a textbox instead of a label. You can format it to look the same.

 

[scheeps]

Thanks Paul.

Any idea which format properties to use? I've tried most of them but can't seem to change the text box to look like a label.

 

[pbaldy]

I need to run to a meeting, but I'm thinking things like back color, back style, border, etc.