Invisible Text! What can you do?

[BadRabbit]

I was going to give it a rest with the questions, but this problem really bites the bag.

I have a simple form on which is a button. Press the button and it loads a value into one of the fields using a VB sub. Which is great, except it uses INVISIBLE text. It looks like it hasn't worked, but it's there (cut & paste into word proves it)! And if I change the foreground properties, the text appears! And it stays visible when I change them back to their original value.

This happens whatever method I use to put text in a field, except for straight query and user input. Why would it do this? All I want to do is populate a field with a default value at a certain point in the form!

Help much appreciated!

 

[Darrylles]

Hi Bad,

Never heard of this before, searched MS Knowledge Base with no joy - more detail please?

a)What foreground property is set for the field, and what do you set it to to make it work?
b)Can you show the VB assignment statement that populates the field please? (Full sub would be better).
c)This really sounds like the form is corrupted - have you tried compact & repair database?

Hope someone has seen this before and solves it before you get back with above.

Regards,

Darrylle



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[ssecca]

Not a chance Darrylle, I think he's in good hands with you.

Good Luck
ssecca

 

[BadRabbit]

Hi Darrylle,

Well, out of sheer frustration I deleted the entire form and re-created it. I used the same VB (cut & pasted) and now it works. I can't explain it at all!

I wasn't imagining it - the text was there, and when you selected it you could see the black selection box, but no text! Altering any value in the properties to something else, then back again, and the text re-appeared.

I agree - it looks like some corruption - I'm just glad it's sorted. Man - 4 hrs on 5 lines of code... must be a record!

Cheers for the reply!