Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help of listbox with number display

Status
Not open for further replies.

dickylam

IS-IT--Management
Jun 24, 2001
86
I am facing a trouble. I have a remote view table wants to show in listbox.

For example, 3 fields, the first one is char type, the second and last is numeric type. Let these 3 fields be fld1,fld2,fld3 respectively.

If specify the columncounts = 3 and rowsourcetype = 6, the rowsource = 'fld1,fld2,fld3'

It shows the result, but the alignment is TOO BAD. Although I try to specify rowsource = 'transform(fld1),transform(fld2,'999,999.99'),transform(fld3,'999,999,999.99')', but the result is still same, it looks urgly in display

How to do it. Please help, urgent

thanks
 
dickylam:

Have you played with the ListBox's COLUMNWIDTHS property, or tried changing the FONTNAME to Courier or Courier New, both fixed-character widths?

What's so ugly about it?

Al
 
The fields won't line up vertically no matter what you do unless you use a non-proportional font like Courier or System. A combo-box may be what you need to solve this problem, or use a non-proportional font.

Good Luck.

Mike Krausnick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top