I have created a fairly complex report that compares current YTD sales data with prior year. I've used list boxes in the report to create the data using SQL in the rowsource property. Everything displays fine in print preview and on hardcopy after printing. For some reason the data inside the list boxes disappears when I export it to ANY format. For that matter, when I export it to Excel, nothing appears at all...I get a beautiful blank worksheet. I've checked all of the properties on the report/list box and I've tried exporting to every format and nothing seems to correct it. Any assistance would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Listbox contents on report disappear when exported.
- Thread starter ehoody
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question