number format

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

hello All.

I am entering a value, in a form, that will mainly be currency, however on
occasions it could be a percent or a fixed number.
Being stored as currency, percentage or fixed is not important as long as
the display of the number is in the correct format. I was hoping to do this
in continious forms using conditional formatting. However the option for
changing the format is not available.

My second option is to have seperate tables for the currency, percentage and
units

Can anyone else think of a better method?
 
I think your second option is probably the best idea. Conditional formatting
is going to be very difficult. How would you define the conditions?

The fact that you are needing to do this, also suggests bad database design
and there probably is a much better way of organizing your tables.

Maybe include why you need to do this, what the table is for and someone
should be able to suggest a better design.

HTH

Rico
 
Hi Chris,

A currency field can only store a number. How will you specify when
entering the data whether it is a sum of money, or a percentage, or
something else?

Tell us that, and someone should be able to work out how to display
things the way you want.
 
It's a system for a college.
I've been asked for a form where a text box is filled in as a description.
the second textbox will contain the numeric value. However the format would
have to be chosen by the user.

The fixed rates describe the amount of units that have been completed
relating to a course
The percentage is how much of a course that is completed
The currency is the amount of money that is left relating to a course

Units 24 fixed
Completed 64% percentage
budget £1,000 currency

I'm thinking the three tables is the best idea, having option buttons for
the user to select there options.
 
Back
Top