Dim string as currency

Can anyone help? I am defining a string as currency, and then putting it out to a message box, but it still displays incorrectly (£2.5 instead of £2.50 etc).

I think it may be that I run sql which selects a column into a string and then I set my currency string equal to the sql string. E.g.

dim strcost as currency

"select [cost] as sqlcost from......."

strcost = rst!sqlcost

Any ideas on how I can get this to work?

VB6? look here

http://msdn.microsoft.com/library/e...matCurrency.asp