Long Text Type field not shows in list box

[hrdpgajjar]

Hi all,
I have a table in which a field name TPADate is set to long text. Now i am planning to make a query design which shows all the table columns in a listbox including TPADate column in it. All other short text columns shows in list box but long text column such as TPADate not shows.

Is there any way to do it?

 

[June7]

Why is a field named TPADate a text type and not Date/Time?

Long text field should show but will be truncated.

 

[hrdpgajjar]

Why is a field named TPADate a text type and not Date/Time?

Long text field should show but will be truncated.

ohh sorry its TPA data not date. anyway so there is no way to use long text in list box queries right?

 

[CJ_London]

Long text should work but will only display the first 255 chars - Assuming it is not richtext and the first char is not a carriage return

 

[MajP]

You may want to use a subform formatted to work as a listbox. You will have more flexibility.

alternating row colors in ListBox

Hi All. Is it possible to create alternate row colors in a form ListBox control in VBA Access? If yes. Can someone show how it to do? Is it possible to change font in header ListBox? Thanks

www.access-programmers.co.uk

 

[gemma-the-husky]

It might call it a "memo" data type. That's long text >256 chars