Form Becoming Blank

[PreacherUK]

Sorry the subject isnt too helpful

Whats happening is that a particular user is opening and Acess2K db and somehow after she opens the db all the forms become blank. In design view all the forms objects and controls can be seen, moved, edited. New objects and controls can be added, but still the form is totally blank when viewed.

I just wondered if anyone else out there had experienced something similar to this?

Cheers
Dave

 

[mph1]

I have never (fortunately)experienced this and am not sure why you can have objects appear in the desing view but not in the form view. Shouldn't make any difference if the the form is bound or unbound. Have you tried makeing a new form. I do know that at times a form can become corrupted.

HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[BSman]

OK, here's a stupid question. Is the visible property of your controls set to true or false? If the default happens to be false and you didn't notice it, that could be why the controls are not visible.

 

[PreacherUK]

yeah, I created a new form and just threw a button on it to see if it'd survive being opened by the user and it was fine. So I'm at a loss

 

[PreacherUK]

all the control properties are set to true I even considered that the db had been subject to malicious change, that someone had purposely made the change, I figured they could slip some code into the on open event, but there was nothing amiss.

 

[BSman]

If all your controls display values from the source table for the form and there are no records, the form might look blank. (In other words, you have no labels on the form.)

Try setting some of the controls to sunken or raised, with a border that's visible, and even change the background color on a few controls to different colors.

 

[mph1]

It sounds as if your form did become corrupt. If this is true, will most likely never know why.

Suggestion --- open a blank database and import everything from the old into the new. Then create new forms. You should be able to copy the objects from the old form to a new form.



An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[PreacherUK]

I have a secure copy (working with windows teaches that at least). I was hoping there might be a solution/resolution rather than marking it down as 'just one of those windows things'.

Just out of curiosity I tried changing the colour and special effects of some of the controls but still no joy.

I hate to explain these things with "Its coruppt" but it looks to be the answer.

Thanks all for all your help.

Cheers
Dave

 

[randy700]

When you were checking to make sure the visible property was set to Yes on all controls, did you think to check the same property on the Detail section itself?

 

[MinnKota]

I have encountered this on a couple of occasions...

I have a few questions for you...is this user able to enter a new record into a TABLE? Does the form start on a new record? What sort of windows security is in place? Is the database opening as read only?

 

[Draknor39]

I've had this occur several times. Every time it occured for me was because the form was bound to a Stored Procedure or a Query and no Records were returned.

 

[DanJR]

Same here, every time I have encounted this, it has been due to the same reasons as MinnKota and Draknor39 point out --> no records in the underlying recordset.

e.g. setting the form properties 'Data Entry'=Yes and 'Allow Editions'=No for a bound form will create the (un)desired effect.

Cheers,
Dan

 

[PLiNk]

This happened to me during an exam
and I was had a driving lesson, who had to wait outside at the same time as I was rebuilding all the forms from scratch.
Luckily this was in Bournmouth England, and not in Redwood USA, since if it was, I would have told my dear driving teacher that we would now go straight for Bill Gates' house and run him down.

This happens as a result of a Rincewind wizard. (wizards that do more harm than good. Read a discworld book)
It has to do with the wizard is not able to make it right somehow, and you end up with a blank form sometimes. I never figured out what made this happen, cause sometimes it worked. It's weird.

 

[RichardBott]

PreacherBNY, here's the solution I posted to my own thread which also dealt with forms showing as blank when opened but OK in Design view. I would have pointed you there but don't know how to get the thread number. Anyway, here's my solution, maybe it can help you...

The problem was I had created a query for the form which had two separate but related tables that each referenced a third table! Now, if you think about this, it doesn't make too much sense to have this in a query, does it - but I did. I had built the query in accordance with my complex data model. It's OK to have this type of 'circular reference' when data modeling but not in a query.

I solved the problem by removing one of the relational links in the view. This solved my problem! I wonder if it may be a solution to others' problems. Let me know it could be.

Richard.
'Education is what survives after what has been learned has been forgotten' B.F.Skinner (I think)