G
Guest
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.
J
Joseph Meehan
tdshort said:I need to create a custom number format that used a space instead of a
decimal point in a form. Can someone help me?
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?
G
Guest
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)
J
Joseph Meehan
tdshort said: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)
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?
G
Guest
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.
J
Joseph Meehan
I have thought about this a few times and while I don't believe there
would be any problems displaying the numbers the way you want, John's sneaky
way should work fine. The problem is going to be the data entry.
You could enter the data into a string then use the John's idea to
change the SPACE to a "." and then update the field. It would take a little
VBA, but not much. How knowledgeable are you in VBA?
would be any problems displaying the numbers the way you want, John's sneaky
way should work fine. The problem is going to be the data entry.
You could enter the data into a string then use the John's idea to
change the SPACE to a "." and then update the field. It would take a little
VBA, but not much. How knowledgeable are you in VBA?
G
Guest
very little. If you could write it step by step I could probably be able to
do it.
do it.
J
Joseph Meehan
tdshort said:very little. If you could write it step by step I could probably be able
to
do it.
"Joseph Meehan" wrote: ....
I am going to suggest that you repost this question with just the part
about the data entry and hopefully someone who dose more VBA than I do will
be able to give you some good advice. If no one responds in a few days try
me again and I will try to set up an example for you.
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.