Formatting problem

[Rob]

I have an unbound text box on the page which is filled with data from a
hidden field in a combo. As advised by someone else I use the following
code:

If Not IsNull(Me!cbodeliveredby) Then
Me!txtaggdelrate = Me!cbodeliveredby.Column(3)
End If

in the control - txtaggdelrate the entry is always 1.5 instead of £1.50 or
2.5 instead of £2.50.

If I ask the combo to show the value instead of hiding it, it comes up with
the £ sign in the place it should be so it is because it is not passing it
on to the text box.

When I try to use a format of currency or £#,##0.00;(£#,##0.00) in the
format property it doesnt work either.

Why could this be happening?

Thanks in advance

Rob