Accent in MS Access

E

Elizabeta

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
 

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

Similar Threads

VBA - (re-) Set a Table Style 2
symbols won't work in form fields 1
searching in MS Access - diacritics 0
accent marks, in Greek alphabet font 2
can i use color accent in ms picture manager 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Delete all data after a symbol in a field 0
Milo: Apostrophe key giving me a-with-an-accent in nonHTML notes 1

Top