Decimal placement

  • Thread starter Thread starter David
  • Start date Start date
D

David

On the single form that I have on my db, is it possible to input intergers
and the form place the decimal point 2 places in from the right? Right now
all it does is add 2 zeros which makes me need to manually place the decimal
point in the proper place. This is way too slow.
I have A2007 with Vista x64.
Thanks

David
 
Davis,
Use then AfterUpdate event of your text control...
Example control name = [YourNum], a bound Single or Double type)

Public Sub YourNum_AfterUpdate()
[YourNum] = [YourNum] / 100
End Sub

Enter 12345... get 123.45

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
On the single form that I have on my db, is it possible to input intergers
and the form place the decimal point 2 places in from the right? Right now
all it does is add 2 zeros which makes me need to manually place the decimal
point in the proper place. This is way too slow.
I have A2007 with Vista x64.
Thanks

David
Click to expand...

Integers are by definition whole numbers and do not have any decimal places!
What's the datatype of the field? What's the nature of the data you're
entering?

If you always want two decimals, I'd suggest using a Currency datatype (that's
datatype, not format) rather than any sort of Number, and set the format to
something like "#.00" or "Currency".
 
David said:
On the single form that I have on my db, is it possible to input intergers
and the form place the decimal point 2 places in from the right? Right now
all it does is add 2 zeros which makes me need to manually place the decimal
point in the proper place. This is way too slow.
I have A2007 with Vista x64.
Click to expand...


Try something like this in the text box's AfterUpdate event:

If Not Me.thetextbox.Text Like "*.*" Then
Me.thetextbox = Me.thetextbox / 100
End If
 
Back
Top