Solved Display issue with VBA code

[Alc]

In the past, I've had the odd db 'lose' its VBA code. I followed the list of known causes I found online, relating to db corruption, and it hasn't happened for a while.

Today, however, I opened a db and found that the VBA windows were all blank. Forms, reports, modules, all showed no code.
Where this is different to previous times is that the code IS present, I just can't see it.

I know it's still there as the various daily processes I run each morning all ran without problems, plus I can see the code if I open the database on a different computer.

Further investigation showed that this applies to all Access databases and that rebooting the affected PC had no effect.

Does anyone know what might be causing this display issue?

 

[June7]

Happens only on this one PC, not others? Maybe bad install of Access.

 

[Alc]

Happens only on this one PC, not others? Maybe bad install of Access.

Thanks for the reply.
This PC has been set up and running for about four years now. Wouldn't a bad install have manifested itself before now?

 

[Uncle Gizmo]

Could it be that the colour of the font of the VBA code has been changed to white, same as the background, and that's why you can't see it?

 

[June7]

Would think so but programs have been known to get corrupted. Something on that PC must have changed. Even a Windows update can do weird things.

Gizmo has interesting thought. I just looked at how this can be done. Look at VBE > Tools > Options > Editor Format.

 

[SHANEMAC51]

I know it's still there as the various daily processes I run each morning all ran without problems, plus I can see the code if I open the database on a different computer.

apparently the system font is damaged on this computer

 

[Alc]

Thanks, all.

I checked the font color and it wasn't the problem.
Spoke to IT and asked for a reinstall. Was told would take a few days.
I asked if they'd sent out any updates that might have caused this and was assured they hadn't.
However, I came in after the weekend to find the PC has been updated in some way and rebooted remotely, after which all is now working again. Coincidence?

 

[GPGeorge]

Thanks, all.

I checked the font color and it wasn't the problem.
Spoke to IT and asked for a reinstall. Was told would take a few days.
I asked if they'd sent out any updates that might have caused this and was assured they hadn't.
However, I came in after the weekend to find the PC has been updated in some way and rebooted remotely, after which all is now working again. Coincidence?

Yes. Coincidentally, someone in IT realized there was a problem just after you alerted someone else in IT that there was a problem.