formatting

[deltauser2006]

I report field that I need formatted correctly. it currently reads:
=[Square Feet] & " s.f."
I need it to be formatted standard with 0 decimal points. How can I do
this? Selecting off the properties options doesn't work. Thanks

 

[fredg]

I report field that I need formatted correctly. it currently reads:
=[Square Feet] & " s.f."
I need it to be formatted standard with 0 decimal points. How can I do
this? Selecting off the properties options doesn't work. Thanks

=Format([Square Feet],"#") & " s.f."

The value will be rounded if it is a decimal.

 

[Steve Schapel]

Deltauser,

Try it like this...
=Int([Square Feet]) & " s.f."

 

[Steve Schapel]

Apologies, I intended:
=CInt([Square Feet]) & " s.f."

 

[deltauser2006]

Apologies, I intended:
=CInt([Square Feet]) & " s.f."

--
Steve Schapel, Microsoft Access MVP

Deltauser,

Try it like this...
=Int([Square Feet]) & " s.f."

Thanks for trying but none of those worked. I can get it into standard
format with
=Format([Square Feet], "Standard") & " s.f." but can't get rid of the
two decimal places.

 

[Steve Schapel]

Deltauser,

Then it looks like neither myself or Fred understand what you mean. Can
you please give some specific examples of what sort of data you have in
the Square Feet field, along with what you want to have shown in the
control, and what you are currently getting with the suggestions we
offered? Thanks.