Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List Box Input Mask
Message
 
 
To
24/04/2001 11:29:04
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00499066
Message ID:
00499199
Views:
34
>I am using a list box to display certain fields from a table. I have set the ROW SOURCE TYPE to 'Alias' and have listed the fields to be displayed in the ROW SOURCE. One of my fields is a logical field, and I am interested in displaying that information as a "Y" or an "N" instead of a "T" or a "F".
>
>Does anyone know a way to accomplish that or am I using the wrong type of control? There are other fields in the control that don't need some sort of input mask.

You can set it to be SQL and write it:
select field1, field2, iif(logicalfield,"Y","N") as LogicalField, field3, etc. from yourTable ... So, it would display just fine.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform