Custom Formatting of Field doesn't transfer to my report

O

Oh Joy!

I have formatted a field in my table to show: @" ft²". However when i run a
report from a query based on this table the formatting no longer appears.
Please help!
 
M

Marshall Barton

Oh said:
I have formatted a field in my table to show: @" ft²". However when i run a
report from a query based on this table the formatting no longer appears.
Click to expand...


Formatting a field in a table is only used when the table is
displayed in sheet view. Depending on when you set the
property it may also be used as a default setting when you
create a text box on a form. The safe thing to do is to set
the Format property in the text box(es) where the value is
displayed.
 
S

strive4peace

use the same format code in the report control Format property

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
 
Top