Currency with three digits

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

Guest

Hi there,

I have been working on a form and I had a problem that I don't know how to
sole. Hopefuly you may help me...

The problem is that when I try to insert a currency field it gives me always
a three digit number, even if it is a one digit number ( i.e. I want to store
35€ and it stores this as 035,00€). How can I solve this?

I tried already to solve this by changing the properties. The only way I
found was to change the format property from currency to fixed number, but in
this way I haven't the € sign in order to give me a currency quotation.

Thanks in advance for you help.

Luís
 
Hi there,

I have been working on a form and I had a problem that I don't know how to
sole. Hopefuly you may help me...

The problem is that when I try to insert a currency field it gives me always
a three digit number, even if it is a one digit number ( i.e. I want to store
35€ and it stores this as 035,00€). How can I solve this?

I tried already to solve this by changing the properties. The only way I
found was to change the format property from currency to fixed number, but in
this way I haven't the € sign in order to give me a currency quotation.
Click to expand...

Use a custom format: rather than a format of Currency or Fixed, use

#,00\€


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thank you John, for your help.

Isn't there any other way rather than this one? Is this an Access bug?

Thank you again for your help

Luís
 
Thank you John, for your help.

Isn't there any other way rather than this one? Is this an Access bug?
Click to expand...

I don't understand. Why is using a custom format a "bug"? The built-in
formats are simply shortcuts to the most commonly used formats. Three
digits with leading zeros is not particularly common in my experience.

You have your choice of millions of possible formats, using the custom
formatting operation. If you want this format, you can use this
format. I guess I'm not sure what you want Access to do!

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