Viewing all field headers on a form

[tbiceps]

I have a form that populates a list box control after an event click. It dynamically builds the column headers based on selected criteria. My problem is the lack of real estate to show all the columns. If the program selects 5 - 10 field headers, then my application works well. If you need to add as many as 20 column headers then I have a serious problem. Is there a different control, or option available. Is there a way to import information into a viewable EXCEL spreadsheet?

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tbiceps]

I know before I research this tip from you that it is sound advice! Thanks again in advance.

 

[stix4t2]

May I ask is excel going to do for you that the listbox can't?

 

[tbiceps]

Excel will give me the ability to populate a spreadsheet with as many as 100 columns if necessary. The idea is to build some type of visual grid that will allow a person/user to compare multiples reports based on column attributes.

 

[PHV]

Another option is to pull infos from Excel with QueryTable objects.
menu Data -> Get external data -> ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stix4t2]

Can you categorize the column attributes so all 100 don't have to be shown at a time. Maybe you could use a tab control or combo box to select. 100 columns is a lot of information at one time.

 

[tbiceps]

That may be a good idea as well. I didn't have a definitive solution, and I was reaching for direction. But I will give this a try.

 

[stix4t2]

Microsoft added a lot of this classification into the new .net stuff. I think it really helps the user when the datasets become large, or in your case when there are a lot of columns. It also allows you to group together similar information for more efficiency in review.

Good Luck