I have a report I am creating. I need to put a semi-colon(;) before a field name. How do I do in design view or what do I do so my report can display the semicolon before the field.

Thanks,
Judy

In the control source for the text box it would be along the lines of:

Iif(isnull([FieldName]),"","; " & [FieldName])

You would need to replace FieldName with the actual name of the field you are wanting to display in the textbox after the semi-colon.

HTH,

Beth M

Hi Beth,

It's giving me an error. The error message is:

Extra ) in query expression 'Iif (isnull([COLAEndDAte]),"","; " & [COLAEndDAte])'

I tried removing the parenthesis but I still get an error.
What do you think I am doing wrong.

Thanks,
Judy

I left off the equal sign in the beginning. It should be:

=Iif (isnull([COLAEndDAte]),"","; " & [COLAEndDAte])

Beth M

Hi Beth,

Now the report is displaying but I get a #Error displayed on the field COLAEndDate. Does this have anything to do with this field being a date field?

Thanks,
Judy

Is the name of your text box also called COLAEndDate? If so, change it to be txtCOLAEndDate and try again.

Yep, it's the same name. I changed it and it worked. Thanks for the help.

Judy

My pleasure.

Beth M