converting numbers to currency

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

Guest

I have a database that has a couple of hundred fields, most are text but I do
have some that I want to set for currency.

Problem: the currency input mask that access has is not what I need. I
would like to just input numbers, then when I press tab, have those numbers
convert to currency.

Example: if I type 123456, after tab I would like it to look like this
$1,234.56
or 3456, after tab I would like it to look like this $34.56

a solution to this problem would help me alot.

Thanks in advance
Paul M
 
Paul,

Having the $ sign and all that is simple, it is just the Format property
of the control set to Currency.

On the After Update event of the control, put code like this...

If IsNull(Me.NameOfControl.OldValue) Then
Me.NameOfControl = Me.NameOfControl / 100
End If
 
Use the following code in the after update event of a control.

If Int(Me.SomeControl) = Me.SomeControl then
Me.SomeControl = Me.SomeControl/100
End If
 
I can't do better than the answer Wayne gave to your similar recent
question here under the subject "Currency Input Mask".
 

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Currency Input mask 3
How to make a new currency symbol 5
Convert number to word in indian currency 2
Is there any way of using any currency converter in EXCEL 4
How to Return Only the Numbers in a Text Field (Plus the Decimal) 9
I type in a number in a cell but it wont convert to currency help 2
currency converter 2

Back
Top