Syntax problem

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

Hello,

I have a txtfield that can take in dimensions (in feet
and inches), therefore the format would be 100'-0",
however, the ' and " give big problems for the sql
statement when searching things (ie: errors, or no
results), is there anyway to change this so this wont
happen, any ideas?. Help is appreciated. thanks

Jill
 
You can use the replace function to deal with this issue.

Replace(Field, """", "I")
This function finds the " in the field and replaces it
with an I (Inches).

Replace(Field, "'", "F")
This one finds the "'" in the field and replaces it with
an F (Feet).

I'm sure you get the idea.

Regards,
Jen
 
It might help your users and prevent errors if you separate the feet and
inches into two separate fields on your form.
 
Back
Top