Member Avatar for shahriar2403

I am getting the list items from a access database to a list box in my form. But it is showing the list items in a line for each items. As the list box is a narrow one, i cant see the whole line. How can i see the whole line in my list box, or make it in a multiline?
Can i write morethan character in a column in ms access? how?

  • 2 Contributors
  • 3 Replies
  • 72 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by QVeen72
Member Avatar for QVeen72

Hi,

Why not increase the Physical Width of the List Box, till whatever ur Form's Width...? Another way round is to Show the Data in a FlexGrid and make the Cell's Property WrapText to true...

REgards
Veena

Member Avatar for shahriar2403

Increasing the physical width is not possible as there are some other buttons in the form. What about the access problem?

Member Avatar for QVeen72

Hi,

I really did not get u what u want abt Access. Like if the Column is Defined for 30 Chars, then u can save 30 chars. and for textField, it is limited to 255 chars. If u want more that that, may be split it across 2-3 Columns or, use a Memo Field, it can hold up to 64K..

Regards
Veena

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.