Insert character into string where necessary.

[George-Bowyer]

Hi.

I am looking for a piece of code that will look in a field and if it contains just one letter character, add a "." to the field after the letter.

If the field is null or already contains more then 1 character, it should be left unaltered.

Many thanks.

 

[Minty]

You can use the Len() function. Something like this in code

If Len(YourField) = 1 Then....

Or in a query

IIF(Len([YourField]) = 1, [YourField] & ".", [YourField])

 

[moke123]

presumably this is a middle name?

try

If len(me.MiddleName) = 1 then
Me.MiddleName = Me.MiddleName & "."
End If

Change the field name to yours.