I believe I have an AutoCorrect Issue with a field name?

B

BobC

I have 4 linked tables in Access 2007. At one point in time I was
having issues with what turned out to be an AutoCorrect associated file
and whether or not AutoCorrect was turned on/off.
Apparently as a fallout to that (just guessing), I have a field name
that comes up 'notes/discrepancies' as the heading of all my queries,
when in fact, the field name in the table (design view) is shown as 'Notes']
What is the best way to fix this issue? The table has thousands of records.
Bob
 
B

BobC

There is two check boxes associated with the autocorrect; do I uncheck
both? I have never decided it that whole thing is good or bad?
Do you have an opinion?
Thanks,
Bob
 
G

Gina Whipp

BobC,

Uncheck both... The majority of Access Developers I deal with consider that
MIS-featrue to cause more harm then good. I myself turn it off... and when
they do any work for me you MUST turn it off or my OCD kicks in and you have
to listen to me rant until I run out of steam!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

John Spencer

Another possibility is that you have assigned a caption to the field and are
viewing the query in datasheet view. If that is the case, Access will show
you the caption property of the field in datasheet view.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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

Add Table Name as Field in an Append Query 1
name autocorrect 2
how field name output same as input 2
Using a field name as variable in a query 1
Combine text values from many records into a single textbox 2
Aliasing a column header field name 2
Include additional fields in or from a totals qry 12
FROM and JOIN Problems 1

Top