how to add "?" at the end of a sentence

[joyaccess1]

Hi,

I have a column in the form for questions, I would need to add a "?" (question mark) at the end of the sentence automatically, how can i do this in the form.

any help will be appreciated

Thanks
Joy

 

[WayneRyan]

Joy,

Use the BeforeUpdate event of the field.

If Right(Me.YourField, 1) <> "." Then
   Me.YourField = Me.YourField & "."
End If

Wayne

 

[joyaccess1]

Perfect, Thanks Wayne.