INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

VBA Userform Listbox headers multi column in Access 2003

VBA Userform Listbox headers multi column in Access 2003

(OP)
I have VBA Userform Listbox in Access 2003 database and I can't work out how to set values for the column headers.

I can set columnHeads = True

which will show the heads above each column but they are empty ie they have no name in them, how to I put the name in them?

I have looked at the rowsource property but it doesn't seem to be what is needed.

Any help would be appreciated

RE: VBA Userform Listbox headers multi column in Access 2003

Colum headers in userform listbox can be added only in excel and only if the list is linked with worksheet via RowRource. In your case you can add labels above or another list with one row.

combo

RE: VBA Userform Listbox headers multi column in Access 2003

(OP)
Hi combo

Everything I read was pointing that way, just couldn't believe it would be so.

Thank you for your help.

RE: VBA Userform Listbox headers multi column in Access 2003

It's not a big loss, built-in headers are rather ugly, no way to remove borders or use different font size/style.

combo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close