 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2005number format
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 > hello All. > [quoted text clipped - 9 lines] > > Can anyone else think of a better method? 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. >hello All. > [quoted text clipped - 9 lines] > >Can anyone else think of a better method? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. 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. > Hi Chris, > [quoted text clipped - 23 lines] > > Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.