Text Boxes with existing data on the form

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

Guest

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?
 
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
 
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
 
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?
 
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?
 
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

Filling a text box on a form with VBA code 4
Incorrect Total on Main Report 3
Condition on the value selected from combox 0
Hello happy new year to all, Text box input for year of purchase 0
text box if statement does not work when displayed in main form 1
Text Box Problem 3
Displaying query result on the same form as selection fields 6
Append query and combo box on the form 1

Back
Top