Hi Karen,
Access has no way of knowing if you want a decimal point or not. If you use
the below procedure there are a few catches to it.
1. You may or may not use the decimal when entering a number.
2. If you do not enter a decimal it will take you entry and divide it by 100
and format the results as currency.
3. if the desired results of the number you enter is to be $88.80 and you do
not use the decimal then you must enter 8880, where if you used the decimal
you could enter 88.8 and get the desired results.
4. If your desired results are $88.00 you must enter 8800 or with the
decimal 88.
Private Sub Text0_AfterUpdate()
If InStr(Text0, ".") = 0 Then
Me.Text0 = Format(Me.Text0 / 100, "currency")
Else
Me.Text0 = Format(Me.Text0, "currency")
End If
End Sub
Glenn P. Jones
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Pamela Zimmerman
Sent: Wednesday, 14 September, 2005 10:47 AM
To: [email protected]
Subject: RE: [AccessDevelopers] enter currency into forms without having to
use decimal points
Assuming you are entering data directly into a table, set the data type of
the field to currency. Of course, if you enter 8888, you'll get $8,888.00,
not $88.88. If you are using a form for entry you can set the format
property of the text box to currency.
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED] Behalf Of cowgirlbikerbabe
> Sent: Monday, September 12, 2005 6:49 PM
> To: [email protected]
> Subject: [AccessDevelopers] enter currency into forms without having
> to use decimal points
>
>
> I do a lot of financial data entry into a simple databases that I've
> created and I use my laptop for 99% of the work. Without a 10-key pad
> to input the numbers I'm going crazy because I usually hit the slash
> mark instead of the decimal point and it completely interrupts the
> flow of my input.
>
> How can I tell Access to automatically put the decimal point into the
> number for me?
>
> Thanks,
>
> Karen
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section. Yahoo!
> Groups Links
>
>
>
>
>
>
>
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
