No report field formatting

[Guest]

I have a report where the source is a query containing a union. The data
field values print but show no formatting. I have set the format in the
report fields to their proper type (currency, percentage, etc.) but they seem
to be ignored.

Is there a way to set the field formatting. I have made sure the field
formatting is set in the tables and in the query components, too, but still
no luck.

Thanks for any help you can provide.

Regards,
Frank

 

[Duane Hookom]

The union query may be creating columns as text where you expect them to be
numeric. To check, view your report's record source in datasheet view and
see if your columns are left or right aligned. Only right-aligned columns
can use currency, ... You can set the control source of the text box to
=Val([YourField])
Make sure you also change the name of the text box so it isn't the name of
the field. You should be able to then set the format for numerics.