Label Wizard bug in Access 97 & 2000

[WayneH]

For the past 2 yrs, I have been struggling with a very annoying bug in all versions of Access except 95. The problem is basically this:

If I use the Label Wizard to creatae a report, I cannot format the numeric fields. i.e. 36.752, no matter how I format it (currency, 2 decimal places etc), prints on the report as 36.752.

I have been working around it by using Access 95, in that version it does work. However, we had a crash, and now we cant find another copy of Access 95 anywhere.

I'm hoping one of you Gurus have heard of this bug before or something, any help would be greatly appreciated

 

[Pat Hartman]

Wow, I've never know anyone who would choose A95 over A97.

Anyway, on the Format Tab (of the properties for the control in question), set the Format to Fixed and the number of decimal places to 2. You must have been using General format which ignores the numer of decimal places specified in the decimal places property.

 

[WayneH]

All the formats are set correctly....!!

The format is set correctly, I've tried it both ways, fixed with 2 decimal places and currency. Niether work.

It seems to me that it isnt formating anything, regardless of what you select.

All the data types are also set correctly.

** Remember this is only when you use the Label Wizard to cretate a report, when using the Report Wizard or creating the report from scratch, the formatting works correctly. **

What I am doing is printing labels for our showroom, we have about 2,000 items, and the Avery Labels come with 12 on a sheet, so the Label Wizard is very useful to get the 12 records on the same page

 

[Rich]

Try =Format([MyField],"Currency")

 

[Pat Hartman]

I built a label report. I saw the problem when the format was set to general. I changed it to fixed and 2 decimal places. It works on my PC. Perhaps there is some service pack you need to apply.

 

[WayneH]

Got it to work..!

Thanks a lot........

When I took out the '=Trim(', which had defaulted using the Label Wizard, it worked.