Silly report question

[dgrdinh]

Simple question in making a report.

I have 4 fields address, city, state, zip. In my report I have a text
box. I would like to combine the fields into the correct format:

Yadi Street, fountain valley, ca 92708

But I dont know how to do the combine. Do I need to use seperate text
boxes? that seems stupid. Is there some way of doing format strings?

thanks

 

[Rick Brandt]

Simple question in making a report.

I have 4 fields address, city, state, zip. In my report I have a text
box. I would like to combine the fields into the correct format:

Yadi Street, fountain valley, ca 92708

But I dont know how to do the combine. Do I need to use seperate text
boxes? that seems stupid. Is there some way of doing format strings?

thanks

=[address] & ", " & [city] & ", " & [state] & " " & [zip]

 

[Marshall Barton]

Simple question in making a report.

I have 4 fields address, city, state, zip. In my report I have a text
box. I would like to combine the fields into the correct format:

Yadi Street, fountain valley, ca 92708

But I dont know how to do the combine. Do I need to use seperate text
boxes? that seems stupid. Is there some way of doing format strings?

The concatenation operators & and + can be used to do that.
The difference between them is that & supresses Null values
while + propogates Null values. In your case, I think you
may want to use a mix of the two. Use a single text box
with an expression like:

=(address + ", ") & (city + ", ") & state & " " & zip

The + will suppress the associated ", " when the
corresponding field has no value (i.e. it's Null).

 

[dgrdinh]

ok, where do i put this statement, in the box or control source?

 

[Marshall Barton]

ok, where do i put this statement, in the box or control source?

In the text box's Control Source property.