Hello,
I have a form which people use to add customers. One of the fields is
"country".
Most of the clients are in the UK, but we have the requirement to have
it spelt out as United Kingdom.
Currently, the country is selected using a combo box which is
connected to a query which pulls through the countries from a table.
I wanted to use the After Update action so that if someone entered
"UK", it would automatically replace it with "United Kingdom".
I used this code:
If cbo.value = "uk" or "UK" then
cbo.value = "United Kingdom"
End If
It gives error 13, type mismatch. I'm guessing that this means the
combo box is using an index value rather than the text value, although
there is only one column (i.e. the text value) in the underlying
query.
Is this what's happening?
Can anyone suggest a way to automate the text replacement?
Many thanks,
Franc.