Accent in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have this problem:

MS Access 2000 front end
MS Access tables and SQL 2000 tables back end (linked tables)

When I have a string containing 'FE' on access form (like customers name)
and I save it to sql table it is automaticaly transforming the E into E with
accent, É.

What I want to know is:

1. How can I prevent this so is not happening (I do not want accent if it is
not enetered as accent)

2. How to do search in access forms, queries to be accent insensitive.
Namely, I can get records only as I have specified them, if I search 'E' I
get results with 'E' and I would like to have 'É' included in my result set.

TIA
 
Hi all,

I have this problem:

MS Access 2000 front end
MS Access tables and SQL 2000 tables back end (linked tables)

When I have a string containing 'FE' on access form (like customers name)
and I save it to sql table it is automaticaly transforming the E into E with
accent, É.

What I want to know is:

1. How can I prevent this so is not happening (I do not want accent if it is
not enetered as accent)

2. How to do search in access forms, queries to be accent insensitive.
Namely, I can get records only as I have specified them, if I search 'E' I
get results with 'E' and I would like to have 'É' included in my result set.

TIA
Click to expand...

Either delete the reference to FE in Tools + Auto Correct Options, or
set the control's Allow AutoCorrect property to No.
 
Thanks, fred,

I was just doing some simple testing and have discovered this autocorrect in
access (which suprises me very much). So, now I know how to prevent this from
happening.

I still need some answer of how to make access queries accent insensitive,
if possible, because I can't match all records.

Thanks!!!
 
Back
Top