Custom Formatting of Field doesn't transfer to my report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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
 
Back
Top