Report created in 2003 not working in 2000

[Gazzer]

Hi

I am using Access 2003 and have created a report which uses Sorting/Grouping and works fine in 2003.

When users open the same report in Access 2000 (SP3) there are various fields missing on the report. For example in the group header section the address fields do not display but the name field from the source query does. There is some vba behind this report but it does not affect this section of the report.

I have overcome the problem by simply opening the report in design on a PC using 2000 and deleting the field and then just replacing them with exactly the same fields with identical properties. It then works fine, which is really odd.

Unfortunately I will not always have access to 2000 so I need to be confident that any report I create in 2003 will work in 2000. There are no error messages when the report is opened in 2000 it just displays blank lines where the data should be and checking the source query confirms the data should be there.

Anyone have any ideas?

 

[1st_time_dad]

Reports in 2003

Hmmm ... the only thing I can think of is that you have used some formatting or function specific to 2003. Is there a property set in this field that wasn't available in 2000? Maybe print out the properties from both 2003 and 2000 computers and see if there are extra fields where you have maybe set a property in one, that doesn't exist in 2000.

Some of us here have 2003 as well, but we have kept all databases and new databases in 2000 format. Seems to have illeviated and problems so far anyway.

Hope this helps. I sometimes I stare at these databases for days until the problem sparks a bulb in my confused head. I love this program and it drives me nuts all in the same breath.

 

[Gazzer]

Report

Thanks for the suggestion. Although I am using Access 2003 the database is in Access 2000 format, sorry I did not make that clear.

I have looked at the report properties and there are more properties in the report in the 2000 version on my PC rather than the 2000 version on the other PC but nothing that looks like it would affect the visibilty of data.

Just one of those things, I guess.