Listbox Data

[mousemat]

Hi

I have a form with several list boxes on, all working fine.

One of list boxes contains Quotation Data, when I highlight one of the quotes in this list box, I have a command button which when clicked, brings up a second form and populates the fields from the data contained in thie list box. This works really well with the exception of the Amount Field.

I can't seem to get the data on the second from to show the currency symbol even though I have set it to Currency. The data contained in the Listbox is curreny and is fed from the table which is also set to currency!

How can I get this to work? Anyone!

 

[mousemat]

No one else had this problem?

 

[Mile-O]

Have you tried the CCur() function?

 

[mousemat]

No i haven't. Have done a search on the forum for details about it but there is nothing here.

Can you explain a little about what it does whilst I look elsewhere for information on it

 

[Mile-O]

No i haven't. Have done a search on the forum for details about it but there is nothing here.

Can you explain a little about what it does whilst I look elsewhere for information on it

Just look in Access's Help Files - it explains exactly what it is.

 

[Rich]

Post the code you are using to populate the form from the listbox

 

[mousemat]

Rich here is the code

=Forms!tbl_Customers1!List35.Column(2)

The first form (tbl_Customers1) remains open, the second form is populated by the details from the listbox35.

Everything else works fine with the exception of column 2. The data in it is £

 

[Mile-O]

Everything else works fine with the exception of column 2. The data in it is £

What does this do?

=CCur(Forms!tbl_Customers1!List35.Column(2))

 

[mousemat]

Works a treat.

Sorry but was called away for some urget IT assistance and never got round to looking at the help files in access. But thanks for that