Custom Numbers

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

Guest

I need to create a custom (currency) number format that uses a space instead
of a decimal point in a form. And then I need to create a formula to
calculate the fields and display it the same way. I also need it to print as
shown in the form. I don't care how it is stored as long as it displays and
prints with a space instead of a decimal point.

It would be great to fore the decimal (space) when entering data.
 
tdshort said:
I need to create a custom (currency) number format that uses a space
instead
of a decimal point in a form. And then I need to create a formula to
calculate the fields and display it the same way. I also need it to print
as shown in the form. I don't care how it is stored as long as it
displays
and prints with a space instead of a decimal point.

It would be great to fore the decimal (space) when entering data.
Click to expand...

Give me a little time, I plan on getting back to you one that one.
Look for it under the original message title "Custom Number formats"
 
Thank you

Joseph Meehan said:
Give me a little time, I plan on getting back to you one that one.
Look for it under the original message title "Custom Number formats"
Click to expand...
 
I need to create a custom (currency) number format that uses a space instead
of a decimal point in a form. And then I need to create a formula to
calculate the fields and display it the same way. I also need it to print as
shown in the form. I don't care how it is stored as long as it displays and
prints with a space instead of a decimal point.

It would be great to fore the decimal (space) when entering data.
Click to expand...

Sneaky one:

Replace(Format$([currencyfield], "#.00"), ".", " ")

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top