CODEWITHSUNDEEP
oracle-databasems-accessvba
bd528
bd528

Reputation: 886

Formatting an individual column in Access "Table/Query" listbox

I have listbox with 1 columns populated with an Oracle based ADODB Recordset using

strsql = "SELECT '£' || expected_cost as ""Cost"""
lstComm.RowSourceType = "Table/Query"
Set lstComm.
Recordset = rs

The query returns £1.58, but the listbox displays #1.58.

If I use

strsql = "trim(TO_CHAR(round(expected_cost,2), 'L9999999999999.99')) as ""Cost"""

The query returns £1.58, but the listbox displays $1.58.

Is there a way to populate the column as UK currency, whilst keeping the RowSourceType as "Table/Query"?

Upvotes: 2

Views: 644

Answers (1)

ccarpenter32
ccarpenter32

Reputation: 1077

Simple answer: Yes.

The easiest (and best) way to accomplish this is to use a Currency format type. From there you just change the Format field from Currency to £#,##0.00;(£#,##0.00)

Upvotes: 1

Related Questions