Re: Currency symbol question

Format in the design view should give you this option.

"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9904E4F1-A3E7-4B00-A53B-F93F0D08F554@xxxxxxxxxxxxxxxx
Hello,

How can I do that for a Combo Box if one of the fields is Currency?

Thanks

James

"Rli" wrote:

Perfect....
thank you very much...

"Brendan Reynolds" wrote:

Instead of specifying the format in design view, set it
programmatically in
the Open event of the form ...

Private Sub Form_Open(Cancel As Integer)

Me.TestNum.Format = "Currency"

End Sub

--
Brendan Reynolds
Access MVP

"Rli" <Rli@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD3C168F-CE5C-440F-BB91-AACF3A706F09@xxxxxxxxxxxxxxxx
Hi all,(sorry for posting this question before in the wrong group)
I am having trouble with my form fields with currency format.
When one chooses "currency" in the format property of a field, it
pics up
the
regional settings of windows (euro in my case).
So running the form the form field shows 1,00 ? for instance.

Now i save the form and quit the database and transport this database
to
another computer with different regional settings (dollars for
example)(or
i
change my regional settings on my computer). Now i would like the
database
to
pic up automatically those settings and display
the form field as 1.00 $

But it does not....when saving the form on the 'euro'machine the
format
property is actually saved as
#'##0.00 ?;-#'##0.00 ?
so hard coding the euro-sign (but the decimal comma is automatically
changed
in a dot however????)
Am i wright, Is there a way to do this correctly ?






.

Relevant Pages

  • RE: Regional settings modification
    ... Country Text Indexed ... This application is intended for different countries and differend currency ... They are still derived from the regional settings. ... simply copied the pound symbol and used it in the format property for text ...
    (microsoft.public.access.modulesdaovba)
  • Re: Regional settings modification
    ... I am trying to avoid using Currency format, I use "standard" format instead, which do not show any currency symbol, and if symbol required - I showed it in a separate field. ... as for decimal symbol - I think there is no way to solve this, unless you change regional settings, what, as Doug mentioned, is A Bad Thing. ... "Rob" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • RE: Regional settings modification
    ... This application is intended for different countries and differend currency ... They are still derived from the regional settings. ... simply copied the pound symbol and used it in the format property for text ... Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: change $ to £ in time and billing database template
    ... Assuming that your regional settings are correctly set for your local, ... specifically the section labelled 'Currency ... Format' ... ... and choose the option 'Update Format everywhere BillingRate ...
    (microsoft.public.access.gettingstarted)
  • Re: decimal symbol doubt...
    ... manage myself through code the saving of the data into the database. ... I will go with your suggestion: changing the regional settings and see what ... should always refer to dates in SQL using US date format. ... literals in a SQL string or a saved query. ...
    (microsoft.public.access.modulesdaovba)
Loading