Problem with Data Access Page and Field Names.

S

StevenE

I am having a problem with Field names on a data access page.
When I create a group level and use a field that is only numbers the data
access page does not work.

Ex. Group level Field name " 100100"
Data access page fails with an error.
"Can't filter records. The field name specified in the GroupFilterField
property must contain values that have the same or a compatible data type as
the values in the group filter control"


If I rename the field to "Testname"
the Data access page group level works fine.

I am accessing a database that I cannot rename the fields. I have tested
this over and over again with a copy of the database and any field name with
numbers does not work.

Anyone have any idea around this ?

Thanks
Steven
 
S

Sylvain Lafontaine

Maybe enclosing your field names with [] instead of " ... " or give them an
alias would solve your problem, something like:

Select [ 100100] from ...

or
Select [ 100100] as F100100 from ....

This is only a suggestion as I didn't try to reproduce your problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top