Need to add decimal to field for displaying

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

Guest

Hello -

I have a database field containing the value of 2330. I need to display
this as 23.30. The field is display only, I do not want to store this as a
decimal in the database.

I have tried the following:
* Creating a unbound field, with the control source pointing to this field.
The format is currence and I have two decimal places. I get $2330.00, not
quite what I want.
* I did a manual select based upon another field and divided the number
/100. Nothing happened.

Is there anything else I should be trying?
 
Create an unbound textbox and set the source as = me.actualtextbox / 100
 
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

Currency Field 5
Decimal places in forms 2
Using Numbers and decimals 7
Display of numerical value with decimals in a text box 5
Display fixed decimal place in Access forms 3
Display 3 decimals in combo box 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Rounding decimal values in forms and reports 2

Back
Top