Simple select query with text box argument criteria (127 char limi

[SVP]

I'm having an issue using text box values as criteria arguments for an access
query. Example:

Select * from table1 where textfield1 = [Forms]![Form1]![Text0]

If [Forms]![Form1]![Text0] is less or equal 127 characters, the query works
fine.
If [Forms]![Form1]![Text0] is more than 127 characters, the query bombs and
doesn't run at all (Note that I get no errors returned)

version: Access 2000 sp3

any help would be appreciated

 

[[MVP] S.Clark]

What does adding quotes(doublequote apostrophe doublequote) do for you?

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] &
"'"

Afterall, it is a text field, right?

 

[SVP]

As suggested I tried:

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] & "'"
and
Select * from table1 where textfield1 = "'" & [Forms]![Form1]![Text0] & "'"

And still have the same problem.

Sherwin

What does adding quotes(doublequote apostrophe doublequote) do for you?

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] &
"'"

Afterall, it is a text field, right?

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

I'm having an issue using text box values as criteria arguments for an
access
query. Example:

Select * from table1 where textfield1 = [Forms]![Form1]![Text0]

If [Forms]![Form1]![Text0] is less or equal 127 characters, the query
works
fine.
If [Forms]![Form1]![Text0] is more than 127 characters, the query bombs
and
doesn't run at all (Note that I get no errors returned)

version: Access 2000 sp3

any help would be appreciated

 

[[MVP] S.Clark]

Ok, I need to admit that I have no idea what I was thinking when I gave this
response.

I don't see anything incorrect about your original syntax, but perhaps there
is a limitation to the parameter. If that is the case, maybe you can query
on a integer value instead of the long text. (I don't know the structure of
the table). It is rather odd to need to query an exact string that is that
long.

As suggested I tried:

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] &
"'"
and
Select * from table1 where textfield1 = "'" & [Forms]![Form1]![Text0] &
"'"

And still have the same problem.

Sherwin

What does adding quotes(doublequote apostrophe doublequote) do for you?

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] &
"'"

Afterall, it is a text field, right?

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

I'm having an issue using text box values as criteria arguments for an
access
query. Example:

Select * from table1 where textfield1 = [Forms]![Form1]![Text0]

If [Forms]![Form1]![Text0] is less or equal 127 characters, the query
works
fine.
If [Forms]![Form1]![Text0] is more than 127 characters, the query bombs
and
doesn't run at all (Note that I get no errors returned)

version: Access 2000 sp3

any help would be appreciated

 

[SVP]

Looks like a limitation to the parameter. I will assume so and try to find a
way around it. I'm surprised there is no KB article on this. In any case,
thanks for your time.

Ok, I need to admit that I have no idea what I was thinking when I gave this
response.

I don't see anything incorrect about your original syntax, but perhaps there
is a limitation to the parameter. If that is the case, maybe you can query
on a integer value instead of the long text. (I don't know the structure of
the table). It is rather odd to need to query an exact string that is that
long.

As suggested I tried:

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] &
"'"
and
Select * from table1 where textfield1 = "'" & [Forms]![Form1]![Text0] &
"'"

And still have the same problem.

Sherwin

What does adding quotes(doublequote apostrophe doublequote) do for you?

Select * from table1 where textfield1 = & "'" & [Forms]![Form1]![Text0] &
"'"

Afterall, it is a text field, right?

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

I'm having an issue using text box values as criteria arguments for an
access
query. Example:

Select * from table1 where textfield1 = [Forms]![Form1]![Text0]

If [Forms]![Form1]![Text0] is less or equal 127 characters, the query
works
fine.
If [Forms]![Form1]![Text0] is more than 127 characters, the query bombs
and
doesn't run at all (Note that I get no errors returned)

version: Access 2000 sp3

any help would be appreciated