Recent content by WayneH

Rock On! My new Fuzzy Friend...!! ......... I shoulda figuerd as much..... anyhow..Thanks a lot ....

no dice..... it's definitively creating the WHERE statement correctly........ cause when I change the dropdown list value......the syntax error...is reflecting it..... so Go figure.....

Nope...it didnt work...... thanks anyway thoug my fuzzy buddy...

I'm having a very similar and annoying problem... I'm printing a simple whouse report..... the report is invoked via a form where the user selects a value from a drop down list ..... this value is the criteria that I am trying to create my WHERE clause with .... My RecordSource for the...

Got it to work..! Thanks a lot........ When I took out the '=Trim(', which had defaulted using the Label Wizard, it worked.

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...

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)...

Label Wizard bug in Access 97 & 2000 For the past 2 yrs I have been working around a very annoying bug in all versions of Access, except 95. Access 95 is the only version that I have seen it work, the problem is this: When I create a report using the Label Wizard, I cannot get the numeric...