Syntax problem

[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

 

[Jen]

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

 

[caimito]

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