R
Rick
hi all,
using the dbrw, i have setup a connection to a db table and all is working
just fine.
when i initially setup the db thru fp2002, i had fp create the table for me
and then i opened it in access 2002 and changed the customername field to
store data in that field as all caps(uppercase).
if i submit data to the customername field thru the submission form created
by the dbrw in lower case and then open the db table in access, the data is
stored in upper case.
however, if i view the results thru a query after submitting the data, the
data appears in the query just as i entered it into the submission form.
what am i missing? it seems to me that the query should display the data the
way it is now stored in the db field.
tia
using the dbrw, i have setup a connection to a db table and all is working
just fine.
when i initially setup the db thru fp2002, i had fp create the table for me
and then i opened it in access 2002 and changed the customername field to
store data in that field as all caps(uppercase).
if i submit data to the customername field thru the submission form created
by the dbrw in lower case and then open the db table in access, the data is
stored in upper case.
however, if i view the results thru a query after submitting the data, the
data appears in the query just as i entered it into the submission form.
what am i missing? it seems to me that the query should display the data the
way it is now stored in the db field.
tia