Displaying Currency

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

David

I have a Table with a field to hold the "Rate" for a Jobe or the work "Price"
if it is a fixed price. Because of this the field is set to "Text".
On a form I have a bound Textbox to the field.
I would like the Textbox to display the "Rate" as Currency but because it is
Text it cannot do this even though the Textbox is set to Currency.
If I Unbind the Textbox and fill it in Code I can check for the word "Price"
and convert anything else before entering the data. As there are quite a few
Textboxes on the form I would prefere to formate the bound Textbox if
posible. Does anybody knoe if this can be done or have I got to programe each
Textbox.
 
On Wed, 24 Mar 2010 03:32:01 -0700, David

I think you need an additional field: UnitPrice (currency), and
another one Units (probably integer if you bill in hourly increments).
Both are required fields.

For "Rate" work you may have UnitPrice=$50, Units = 100.
For "Price" work you may have UnitPrice=$3000, Units=1 (per
definition).

-Tom.
Microsoft Access MVP
 
Code is the way to go here. Write a standard module function using:

Screen.ActiveControl

and if there are other terms than "Price" use an argument and a Select Case
statement.

Now, select all the textboxes on your form, open the property sheet and on
the event tab, go to the GotFocus event and add:

=FunctionName()

substituting you function name, of course. If you do have arguments, you'll
need to do them separately.
 
Back
Top