How to set a VERY long condition in conditional formatting

Question

I have a very long condition, about 3000 characters. Access only takes about one tenth.

Is there any other way to set conditional formatting in a text box, moreover, through a dialog, or can I do it in VBA, and if so, then HOW?

I have conditional formatting in a bunch of text fields that start when a report is opened.

Answer 1

It would be interesting to know if the VBA approach worked?

: 3000- . 1 , false/true 0/1; mulitple, 0, 1, 2 3, , . (): [HiddenFieldName] = ConditionValue

Answer 2

Access, FormatConditions (Add, Delete, Modify), FormatConditions VBA. , , .

, , FormatConditions. .

Answer 3

, VBA. http://support.microsoft.com/kb/304104 .

, . , VBA AddFormats:

Public Function HighLightForeignKeys(argFieldName As String, argFieldValue As Integer)
    Dim FormatCondition As String
    Dim CodeReception As Integer
    FormatCondition = "[" & argFieldName & "] = " & ArgFieldValue
    With Me.ID
        .FormatConditions.Delete
        .FormatConditions.Add acExpression, , FormatCondition
        .FormatConditions(0).BackColor = 16510422
        AddFormats Me.ID, Me
    End With

End Function 

Answer 4

, , , , . VBA - , .

I have always resorted to using the "zoom" function, available by pressing the SHIFT-F2 key. Is that what you were? I think it returns multiple versions of Access.

A good set of Access shortcuts can be found here: http://www.joyedaniels.com/keys_access.htm