T
tdshort
I need to create a custom number format that used a space instead of a
decimal point in a form. Can someone help me?
decimal point in a form. Can someone help me?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
tdshort
Joseph Meehan said:A little more information please.
Do you want to store the numbers that way? Display them that way? Will
you be using them as numbers (add subtract, multiply etc.) them?
--
Joseph E. Meehan
26 + 6 = 1 It's Irish Math
It is actually a formula and it doesn't matter how it is stored as long as it is separated in the form and will print as shown on the form. (the form is used as a subreport) (examples: 125 55, 99 01)
T
tdshort
Joseph Meehan said:I am still not sure what you have and what you need.
I am guessing that someone will be entering the data (numbers) in a
Microsoft Access Database form and the only use of those numbers is to print
out some sort of a report showing the numbers with spaces. Further I am
guessing that you want to allow them to press the period key and have the
result show as a space on the form and on the printed report.
Will they always be entering a number, or numbers, with two decimals?
Will some have one like 125.5 and if so do you want to force the use to
enter a "0" or will it always be 125.05 or maybe always 125.50 or may it
be one or the other.
If the user were to enter 125 does that mean 1.25 or 125.00 will the
user always get this right or do we need to force the user to enter the
decimal and two additional digits?
It appease you may have two such numbers entered and-or printed at the
same time. Will this always be the case or may the number change?
How large and small a number is possible. For example could one number
be 125.25 and the next 12563.25 and the next be 21.90?
If you have an upper limit of 999.99 and a lower limit of 000.01 would
25.45 need to be displayed as
25 45 or 025 45?
--
Joseph E. Meehan
26 + 6 = 1 It's Irish Math
The number is currency with a space instead of the decimal. It would be great to force the decimal (space) when entering data. I doubt the number would ever be longer then 999.99. They will be entering the number in the form and then I will need a formula to calculate the numbers and also display the number the same way.
T
tdshort
very little. If you could write it step by step I could probably be able to
do it.
do it.