CR LF in Field

[technoGirl007]

Hi All,

I am getting a CR & LF characters attached at the end of one of the fields
when a record is created in a ACCESS DB. This validation error does not occur
in any pattern, just happens sporadically.

My program parses each character, validating that are ASCII values 32 through
122; if not, it will not allow the user to continue with the program.

The field that this occurs in comes from a CFFORM, CF Input BOX (Text). This
is a NOT a memo box. It is a single line text box with form validation once the
user submits his/her input.

One thing that I noticed is that it seems to be with user's that use MAC OS
with Safari browsers.

Would anyone know if Mac's have additional key entry capabilities that would
convert any other values to CR character and LF character in a SQL type
database?

I'm currently bagging my head against my keyboard out of sheer frustration not
able to solve this issue.

Thanks,

technoGirl007 :)

[gwgiswebmaster]

have you tried using Trim()?