Currency Format

[damie]

Hi,

I have several tables with information about euros, a query relating to the tables and a report based on the query. Originally, to avoid problems, I produced all the information in numbers (without format) and later, in the report, went to the properties section and changed the format to euros.

For some reason several columns in my report did not change to euros and although when I looked again the Format in Properties did display "euros" when I clicked to try a different format, I was given no options. And these columns remained without displaying euros.

I dicided to go back to the the original tables and change all the formats to euros, and the resulting query did then display euros too. However the report still won't display euros and so now I'm at a loss as to what to do to solve this problem.

Has anyone else had this problem? I really need to have some format as the numbers I'm using are large and without it they are difficult to read quickly.

Thanks.

 

[Rich]

delete the original control, save the report, then drag the field back onto the Report from the field list, save the changes again

 

[damie]

I tried this and, alas, in my format line it won't give me any options to choose from. Is this a bug from office 2003 or is it me? In 11 columns of numbers only 3 don't allow any format whatsoever.

 

[Kryst51]

I know this is an old thread, but I too am having problems displaying a number in Euros. I have values in a list box, and sum those values in a text box that uses a DSUM function. I have set it to Euros at the table level, and query level. The DSUM has a format around it, and I can get it to display the $ symbol but not the euro symbol. The list box won't display either. I have read, by doing a google search, that this may have something to do with my windows settings. I don't want to change my whole computer, (Nor can I as I don't normally work in Euros but in US dollars), I just want Euros for this particular database.

Any Suggestions?

 

[Scooterbug]

The ascii code for the Euro is 128. So, in a query, you can do the following: TotalCost: chr(128) & format([YourCost],"##.##0.00")

The euro symbol will show up. I'm pretty sure you can use the chr(128) for reports as well.

 

[Kryst51]

The ascii code for the Euro is 128. So, in a query, you can do the following: TotalCost: chr(128) & format([YourCost],"##.##0.00")

The euro symbol will show up. I'm pretty sure you can use the chr(128) for reports as well.

Thanks! It worked perfectly for the list box.

Here's what I have for the text box, I get an #Error when I try this, but I am sure I am doing something wrong.

=Chr(128)+Format(DSum("[Amount]","qryStartEndDate"),"#.000\.00")

 

[Scooterbug]

Take out the /

Should look like this:

Chr(128)+Format(DSum("[Amount]","qryStartEndDate"),"#,###.00")

This will display 23456.78 as (euro character)23,456.78

 

[Kryst51]

Take out the /

Should look like this:

Chr(128)+Format(DSum("[Amount]","qryStartEndDate"),"#,###.00")

This will display 23456.78 as (euro character)23,456.78

OK, I did that, I still get the #Error. Just so you can see that I have what you have I'll copy and paste as I did before.

=Chr(128)+Format(DSum("[Amount]","qryStartEndDate"),"#,###.00")

Also, before My list box is populated (Which happens when I select a name from a combo box) the text box does display the Euro sign. I didn't know if this info could be important or not. I also wonder if it has more to do with the DSUM then the formatting?

 

[boblarson]

Take out the /

Should look like this:

Chr(128)+Format(DSum("[Amount]","qryStartEndDate"),"#,###.00")

This will display 23456.78 as (euro character)23,456.78

By the way Scooterbug - if you want to display the character here, just hold your alt key down and type Alt+0128 and it will do so - like:

€23456.78

 

[boblarson]

It should be:

=Chr(128) & Format(DSum("[Amount]","qryStartEndDate"),"#,###.00")

not the + sign

 

[Scooterbug]

By the way Scooterbug - if you want to display the character here, just hold your alt key down and type Alt+0128 and it will do so - like:

€23456.78

*Files the tip away*

 

[Kryst51]

It should be:

=Chr(128) & Format(DSum("[Amount]","qryStartEndDate"),"#,###.00")

not the + sign

OK, I tried that as well and still got the error so I put the text box back to what I had before trying to my original DSUM expression:

=Format(DSum("[Amount]","qryStartEndDate"),"Currency")

and I get an error, so I don't think it is necessarily this text box that's producting the error, could it be that the formatting is done on the list box value?

 

[boblarson]

No, it could be nulls. Try

=Format(Nz(DSum("[Amount]","qryStartEndDate"),"Currency"),0)

 

[Kryst51]

No, it could be nulls. Try

=Format(Nz(DSum("[Amount]","qryStartEndDate"),"Currency"),0)

No, that didn't work either. You know, before I started trying to do more complex things, I felt that I was pretty good with access. Now I feel like I hardly know anything. This is the same stupid DB you helped me with before..... I really appreciate your help, I am frustrated with myself at the moment.

It's on the frmTransactionLookup at the bottom, I want to get a total of whatever values are in the listbox.

 

[boblarson]

Okay, here you go. I had to go remove your formatting from the queries and delete the text box and add it back in. There is a format called EURO so you don't need to concatenate the € sign onto it or use the format function.

See attached.

 

[Kryst51]

Okay, here you go. I had to go remove your formatting from the queries and delete the text box and add it back in. There is a format called EURO so you don't need to concatenate the € sign onto it or use the format function.

See attached.

Thanks for the help. It certainly works. By the way, how do you have time to answer so many questions?

 

[boblarson]

Thanks for the help. It certainly works. By the way, how do you have time to answer so many questions?

I finish my work very quickly and so have a lot of time available.