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.
--
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
"Jim" <joc[ at ]nospam.net> wrote in message
news:Xns983EE3A20D715Joconnoraspsmnet[ at ]216.196.97.136...
[Quoted Text] > 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
|