List Box Display Limit

hello there,

is there a limitation on how much a list box can display for each item row?

because i am retrieveing a memo column from the database which contains long sentences.

As of now, the sentences (memo) im retrieveing into the list box are broken up into shorter sentences.

Any ideas?

Thank You

Astro

I've got no idea how long each item can be, but why are you using a list box?

I've always used textboxes for this sort of data (with MultiLine set to True, and ScrollBars set appropriately).

hello si_the_geek

i was just informed that a listbox holds up to a limit of 255 characters.

as for textbox, there is no recordset property which i will need to modify table values.

do you have any other suggestions?

thanks for replying anyway =)

Astro

Ok, I'm confused - where are you doing this? Is it in Access?

hey yeap =P Access!

Astro

If your form is bound to a table you can link the textbox to the field using the "Control Source" property.

If it isn't bound, you have full control over what is placed in the textbox, and the data (you just need to load your own recordset).