Search results

  1. C

    Forecolor Property - Overflow Error

    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...
  2. C

    SQL Statement with Inches

    I have had the same problem and used the Replace function to deal with it. Dim strUse As String strUse = Replace(me.Text1, Chr(34), " inches") Whenever me.Text1 contains something like: 13' 11" The value is changed to: 13' 11 inches You can then use strUse as you wish with worrying about an...
  3. C

    Forecolor Property - Overflow Error

    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...
Top Bottom