Text Boxes with existing data on the form

M

Mickey

I created a text box which gets it's information from the form itself.
Everything is ok except when it locates the balance field. I am unable to
get a correct amount when a zero is on the end. example $3.30 will display
$3.3. What am I doing wrong?
 
S

Sharkbyte

You need to change the formatting, on the text box. Change the Format
property to Currency.

If you still have the problem, change DecimalPlaces to 2.

Sharkbyte
 
D

Douglas J Steele

You're not doing anything wrong. 3.30 and 3.3 are the same number.

If you need the 0 to display, try setting the format of the text box to #.00
 
M

Mickey

That is where my problem lies. I did make sure both fields were set at
currency with two decimal places. Still unable to get the correct amount to
show. Do you have any other suggestions?
 
M

Mickey

Good suggestion but it did not work. I think I'm at my wits end with this
one! Can you think of any other way to get the zero to display?
 
Top