Text Boxes

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Good Morning All
I have 2 text boxes in my report
1 text box is for Accurate numbers (1 decimal Place)
The second is for Reporting numbers ( O Decimal Places)
What I require is the Reporting numbers text box to use
the Accurate numbers text box as a control source and
round the figure to 0 decimal places.
Can someone please help with this.
Regards
Michael
 
Use the same underlying Field as Control Source for both, and specify the
number of decimal places in the Format. Check to see that the numbers are
rounded to your satisfaction -- Microsoft uses a form of rounding that some
do not like, a "banker's rounding". If the rounding is OK, then everything's
OK. If not, post back and someone will, no doubt, be able to refer you to
information on rounding techinques.

Larry Linson
Microsoft Access MVP
 
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

Getting decimal places to display in a report in text boxes 1
format and decimals in control text 1
Access 2007,reports,VBA 2
Decimal places in a calculated Text Box 9
Numbers after decimal 1
Text Box formatting Access 2003 2
Only first digit of a number shows on Report i.e., 600 shows 6 10
Number Field Automatically Rounding Decimals 3

Back
Top