Subform ghosting image

R

Robert_DubYa

I have created a subform (it looks like a query to the user) that has a check
box as a field. The check box has to be scrolled over to the right for the
user to view. The problem I have is that the background for the check box
contains data from a field that was orginally in that position.

Example: ([] is my checkbox and the subform has cells much like excel)

2.75[]

If I click into the cell the ghosted portion goes away, but still looks funny.

background: I have been having trouble with particular field. I have not
been able to get the field to show up as a checkbox from the values list when
I drag it to the subform. I have to create the checkbox and set the data
equal to the field in my query.


Help with this problem is much appreciated. Let me know if you need more
info from me.

robert
 
A

Arvin Meyer [MVP]

It may be a video card or driver problem, or it may be a corrupted form. Try
the following:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 
Top