ListBox column has lost formatting.

F

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.
 
A

AccessVandal via AccessMonster.com

Hi Frank,

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

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"
 
A

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?
 
D

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;
 
Top