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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting date from date/time field in access report 3
Displaying Text field from linked Excel table in reports 3
access 2010 date field 3
Can't create a report from my query in Access 1
Masking a field in Report only 2
Format numbers on a report in 2007 6
Report based on query shows no data 1
Report Update Fields 0

Back
Top