ListBox column has lost formatting.

[Frank Martin]

Suddenly the currency columns in my list
boxes have lost the currency formatting.

The underlying queries are OK in this
respect.

Please help.

 

[AccessVandal via AccessMonster.com]

Hi Frank,

Post your SQL string for the listbox. Most likely the field "Format
("somefield", "$#.##") As SomeName" is missing.

 

[Frank Martin]

Thank you: here is the SQL:

SELECT DISTINCTROW
Qry081299INVOICEforFormEACH.AddressesID,
Qry081299INVOICEforFormEACH.People,
Qry081299INVOICEforFormEACH.InvoiceDate,
Qry081299INVOICEforFormEACH.InvoiceNo,
Qry081299INVOICEforFormEACH.SumOfExpr3,
Qry081299INVOICEforFormEACH.OrderID
FROM Qry081299INVOICEforFormEACH
ORDER BY
Qry081299INVOICEforFormEACH.InvoiceNo DESC;

(The column in question is: "SumOfExpr3")


Regards, Frank



"AccessVandal via AccessMonster.com"

 

[AccessVandal via AccessMonster.com]

Hi Frank,

It's very likely that you have change the DataType in your table.

What about the Query "Qry081299INVOICEforFormEACH" for the field "SumOfExpr3"?

Did the field in this query was correctly formated?

 

[Douglas J. Steele]

SELECT DISTINCTROW
Qry081299INVOICEforFormEACH.AddressesID,
Qry081299INVOICEforFormEACH.People,
Qry081299INVOICEforFormEACH.InvoiceDate,
Qry081299INVOICEforFormEACH.InvoiceNo,
Format(Qry081299INVOICEforFormEACH.SumOfExpr3, "Currency"),
Qry081299INVOICEforFormEACH.OrderID
FROM Qry081299INVOICEforFormEACH
ORDER BY
Qry081299INVOICEforFormEACH.InvoiceNo DESC;