Format List Box

[tomrector]

I have a form with a Listbox that is filled by query
SELECT ClassDesc FROM classcodes WHERE
Forms!Aclass.CODE=classcodes.code;

Problem is ClassDesc is a memo field and does not "warp" when
displayed in the list box.

As you can see when CODE is selected, it pulls data from classcode
and inserts it in the table associated with the current form the
listbox is in. I requery the listbox in AfterUpdate of the CODE
field.

There may be a better way to do this, I am probably forcing a square
peg in a round hole, any ideas would be appreciated. The database is
to create a Class Listing each month, the user does not want to rekey
data
all the time so I am trying to work as much from one screen (form) as
possible. I am pulling several fields
from other tables based on the CODE field to fill the fields in the
main table, associated with the current form. Problem is minor things
could be changed or added to some of the pulled data in any of the
listboxes. User does not want to have to find the data in another
table, edit it there, then return to current table.


Any ideas on how to warp the listbox with the query on the memo field ?

Tom Rector
(e-mail address removed)

 

[Rick Brandt]

I have a form with a Listbox that is filled by query
SELECT ClassDesc FROM classcodes WHERE
Forms!Aclass.CODE=classcodes.code;

Problem is ClassDesc is a memo field and does not "warp" when
displayed in the list box.

As you can see when CODE is selected, it pulls data from classcode
and inserts it in the table associated with the current form the
listbox is in. I requery the listbox in AfterUpdate of the CODE
field.

There may be a better way to do this, I am probably forcing a square
peg in a round hole, any ideas would be appreciated. The database is
to create a Class Listing each month, the user does not want to rekey
data
all the time so I am trying to work as much from one screen (form) as
possible. I am pulling several fields
from other tables based on the CODE field to fill the fields in the
main table, associated with the current form. Problem is minor things
could be changed or added to some of the pulled data in any of the
listboxes. User does not want to have to find the data in another
table, edit it there, then return to current table.


Any ideas on how to warp the listbox with the query on the memo field
?

Tom Rector
(e-mail address removed)

Use a standard TextBox with a DLookup() function. You cannot make a ListBox
wrap and it will never show more than the first 255 characters anyway.