>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