Semi-colon Functionality

[TheDeceived]

I have a database with a lot of text box fields for the user to enter data into. Through random keyboard mashing, I found out that if a user types something into a text box and it contains a semi-colon (";") anywhere in the string, then anything after that semi-colon disappears. Well I'm assuming it disappears and doesn't try and add it somewhere else.

I know in VBA that if you use the .AddItem functionality of a listbox and then follow it with x amount of variables, each separated with a semi-colon, then it adds them to each column of that listbox.

Is there anyway I can turn off the semi-colon functionality from a text box, or am I going to have to perform a check on every single text box in my form (which currently consists of at least 20 and rising)?



I've already written the function as:

Public Function ReplaceSemiColon(searchString As String) As String

     If InStr(searchString, ";") > 0 Then searchString = Replace(searchString, ";", ":")

     ReplaceSemiColon = searchString
End Function

Which works fine but I really want to avoid having to put this clause into every single text box/combo box that is currently available to the user.

[ajetrumpet]

are the fields bound? if they're unbound, it should not matter, and it really shouldn't matter if the datatype in the box is supposed to be text.

[NoellaG]

Hi,

is there any afterupdate or onkey code attached to the text boxes/form??? Normally a text box can contain as many ";" as you like. Semicolons are known to give some problems when exporting the data , but within Access they shouldn't give any trouble.

gr
NG

[TheDeceived]

are the fields bound? if they're unbound, it should not matter, and it really shouldn't matter if the datatype in the box is supposed to be text.

Nope, all fields are unbound.

Hi,

is there any afterupdate or onkey code attached to the text boxes/form??? Normally a text box can contain as many ";" as you like. Semicolons are known to give some problems when exporting the data , but within Access they shouldn't give any trouble.

gr
N

The text boxes them self have only got the GotFocus, LostFocus and KeyDown events bound to them, but I'm not sure how this would effect it's ability to read semi-colons as a command rather than just a character.