Are these bugs in access 2003 forms?

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

Hi, I have two reproducible errors in access 2003 forms.

1) I have a form with a sub form set to be datasheet view. In design view I
set the background colour of a text box on this subform to blue and it goes
blue. However when the form is displayed, the textbox is still white. I'm
sure this procedure worked fine in access 2000.
The only way I could get round this was to set the text box with conditional
formatting with a condition that would always be met. (The default
conditional format colour was ignored as well)

2) Frequently, in access 2000, when designing the control source query of a
form (embeded, not as a stand alone query) I would run the query to check
that it returned the correct data. Doing this in access 2003 causes the
machine to freeze, and then after about 20s to report a fatal error and shut
down access. Happens every time.

Are these new features in 2003?
Howard
 
#1. AFAIK, the backcolor has never worked in datasheet view.
Perhaps you were using Continous view before?

#2. Access 2000 and 2003 use the same data engine (JET 4), so this could
indicate a problem with the database. Try this:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.
 
Back
Top