Connecting Tech Pros Worldwide Help | Site Map

Access '97 Bug?

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 06:10 PM
Martin Provencal
Guest
 
Posts: n/a
Default Access '97 Bug?

This is probably known out there already but I can't find anything on
it.

In Access 97, I created a table with a text field using the default
settings. No forms, no queries, just a table. Any text I enter that
ends with a space then the letter "i" (lower case), the "i" is
converted to uppercase! I've not set any formatting in the table and
(because Word, Excel and Access are so intergrated) I turned off
autocorrect in Word. No affect. I'm running W2K w/SP4 and have
Office SR2b installed. I've tried this on two different systems with
the same results.

Anyone come across this before? Is there a fix? I need the text to
remain as entered!

Thanks,
-Martin

  #2  
Old November 12th, 2005, 06:10 PM
Albert D. Kallal
Guest
 
Posts: n/a
Default Re: Access '97 Bug?

Well if it is a bug, then you are in trouble, as a97 is now 4 versions old!

You can disable the autocorrect feature by using tools->autocorrect.

Further, you can also disable individual text boxes on a form by setting the
autocorrect to "no" in the "other" properties tab.

In fact, you REALLY want as a habit to disable the autocorrect for combo
boxes, and list boxes, there is a number of know problems.

And, as note, you generally want to build a form for the user interface, and
not let users edit/see the tables directly. (I susepect you talked about
table view, since you wanted to eliminate as many possbile issues)

However, if you need to display data in a grid, then you can still use
forms. Check out the following screen shots of form that display data as a
grid:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
NoooSPAmkallal@msn.com
http://www.attcanada.net/~kallal.msn


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.