Syntax in report how to add: "text" plus ([field])

[jlvnevada]

Syntax in report how to add: "text" plus ([field])

[June7]

Use concatenation to construct value. Do it in query or in textbox ControlSource property:

="your text here " & [field]

[jlvnevada]

Use concatenation to construct value. Do it in query or in textbox ControlSource property:

="your text here " & [field]

#TYPE! is what displays

[June7]

Displays where - query or textbox? What is the [field] type?

The syntax is correct, I use it frequently.

Post your exact expression (and query if done in query).

[jlvnevada]

Using text box and entering syntax. The field is text.

[June7]

Then I don't know why you are getting that error. Would have to analyse report if you want to provide. Follow instructions at bottom of my post.

[jlvnevada]

I'll have to get back to you on this. Thanks

[jlvnevada]

I set it up in my query to resolve the issue. You did state that. When I have time I will see what the glitch is. thanks