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