Forecolor Property - Overflow Error (1 Viewer)

CHKGreen

New member
Local time
Today, 12:19
Joined
Aug 17, 2011
Messages
3
I'm trying to simply return .forecolor value of a text box.
I am using MsgBox Me.Text1.ForeColor

I keep getting this error in return...
run-time error 6: Overflow

I'm sure it's because Access uses the hex value in the .ForeColor property but I don't know a simple way to return the value I originally typed in.

Thanks in advance for any help.

Newbie.
 

CHKGreen

New member
Local time
Today, 12:19
Joined
Aug 17, 2011
Messages
3
I have found the problem.

The error is occurring because I have reached the limit for the number of controls on a form which is 754 over the lifetime of the form.

This may sound like a lot, but it is easy to do with a tab control.
10 tabs with 70+ objects (lines, labels, text boxes, etc) on each tab will get you to 754 very quickly.

Thanks for the help anyway.
 

Users who are viewing this thread

Top Bottom