Formatting of Listbox Qry Results

[Evan M]

Hello,

I have a table that has 27 fields in it that I would like to show in a
listbox in two columnson a form based on another table [the tables are
linked one-to-one by a unique ID field]: the first column with the field
name and the second with the value in the field. I'd like to base the lstbx
on a query so that it can be done on the fly, but i'm not sure how to go
about doing it... It's rare for me to use a listbox. Any help will be
appreciated! Thanks!

Evan M
evan AT raidologyonesource DOT com

 

[John Nurick]

Hi Evan,

I think it would be simplest to do this with a subform formatted to look
like a listbox. Have one locked textbox for each field, with identical
dimensions, lined up one above the other, with the field names to the
left in labels formatted the same as the textboxes. To make it behave
even more like a listbox, put a transparent commandbutton over each
label/textbox pair, with code so that clicking the button makes both the
label and the textbox look like the selection in a listbox.

Hello,

I have a table that has 27 fields in it that I would like to show in a
listbox in two columnson a form based on another table [the tables are
linked one-to-one by a unique ID field]: the first column with the field
name and the second with the value in the field. I'd like to base the lstbx
on a query so that it can be done on the fly, but i'm not sure how to go
about doing it... It's rare for me to use a listbox. Any help will be
appreciated! Thanks!

Evan M
evan AT raidologyonesource DOT com

 

[Evan M]

Hi John,

Thanks for the suggestion! I think it will work. Have a great day!

Evan M
evan AT radiologyonesource DOT com

Hi Evan,

I think it would be simplest to do this with a subform formatted to look
like a listbox. Have one locked textbox for each field, with identical
dimensions, lined up one above the other, with the field names to the
left in labels formatted the same as the textboxes. To make it behave
even more like a listbox, put a transparent commandbutton over each
label/textbox pair, with code so that clicking the button makes both the
label and the textbox look like the selection in a listbox.

Hello,

I have a table that has 27 fields in it that I would like to show in a
listbox in two columnson a form based on another table [the tables are
linked one-to-one by a unique ID field]: the first column with the field
name and the second with the value in the field. I'd like to base the
lstbx
on a query so that it can be done on the fly, but i'm not sure how to go
about doing it... It's rare for me to use a listbox. Any help will be
appreciated! Thanks!

Evan M
evan AT raidologyonesource DOT com