Check for text box control source

[mcdhappy80]

Can I check if the text box on the form has its control source missing?
If it can can someone provide a code sample please?
In which of the forms events could this be best done?
I was thinking forms Open event.
Thank You.

 

[vbaInet]

The Open event correct. But in what situation will the Control Source of a textbox on a form be empty? Isn't that manually set when you designed the form?

 

[RainLover]

In design view of the form the Properties box will give you the Control Source.

 

[vbaInet]

In design view of the form the Properties box will give you the Control Source.

Lol this user has been on here since 2009, I'm sure he/she knows a thing or thing about where to find the Control Source I've helped him/her out a few times.

 

[RainLover]

Understood but,

The OP did ask about a missing Control Source.

I can only read them as written.

 

[vbaInet]

Fair play but I seeing that it's in the Modules & VBA section I think they are looking for a way to check with code.