list box headings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 15 Sep 2006 03:22 GMT

Hello,

I have a userform with a listbox that is filled with data from an access
database file, using the listbox.list method. It all works fine, but is
there any way to fill in the column headings with the names of the fields,
preferably not directly as the database field names are stupid. I tried
putting the correct header names in the caption property in the database -
no good. Unfortunately, I can not change the field names directly as they
are used by other programs.

using access 2003, word 2003 , DAO to transfer the data.

Thanks

Jim

Reply to this Message

Doug Robbins - Word MVP - 15 Sep 2006 04:45 GMT

You could use labels on the userform, positioned to suit the column widths
in the listbox and with captions being whatever you want them to be.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 11 lines]
>
> Jim

Reply to this Message

Jim - 19 Sep 2006 04:14 GMT

Doug,

Thank you for answering so quickly. That will work perfectly. Like so
many other things, keeping it straightforward is the best

Jim

> You could use labels on the userform, positioned to suit the column
> widths in the listbox and with captions being whatever you want them
> to be.

Reply to this Message