"kirkm" wrote in message ...
Plus I nearly fell over when seeing the Replace command.
I've made lengthy custom routines that do that is a far less
efficient way. (But I found it's not in Access 97 so don't
feel completely stupid!). DateValue was new to me, too.

You're welcome Kirk.
Replace came with VB6 / VBA 2000. Very useful new text functions was
Replace, Split, Join and InstrRev. I use the first two all the time, like:

Sub test()
Dim Sentnc As String
Dim Words() As String
Dim i As Long
Sentnc = InputBox("Say something:")
Words = Split(Sentnc, " ")
For i = LBound(Words) To UBound(Words)
MsgBox Words(i), , "Word " & i & ":"
Next
End Sub

Best wishes Harald