Conditional formatting: Expression Builder : max. number characters :-S

[FL0XN0X]

Dear,

I have an expression I need to use to apply conditional formatting.

The Expression is:

Day([lblDay0].[Caption]) & "/" & Month([lblDay0].[Caption])=Day(DLookUp("[Klantenbestand].[Geboortedatum]";"[Klantenbestand]";"[Klantenbestand].[Naam kind]='" & [Forms]![Bezetting komende 7 dagen]![Naam_kind] & "'" & " AND [Klantenbestand].[Voornaam kind]='" & [Forms]![Bezetting komende 7 dagen]![Voornaam_kind] & "'")) & "/" & Month(DLookUp("[Klantenbestand].[Geboortedatum]";"[Klantenbestand]";"[Klantenbestand].[Naam kind]='" & [Forms]![Bezetting komende 7 dagen]![Naam_kind] & "'" & " AND [Klantenbestand].[Voornaam kind]='" & [Forms]![Bezetting komende 7 dagen]![Voornaam_kind] & "'"))

However, the Expression Builder does not allow me to copy/paste the whole formula, due to ??? max number of characters? If so, does anyone know a workaround? The conditional formatting must color the background color of a textbox in case the condition is met.

Thank you in advance.
Kind regards,


Bart

[ranman256]

DONT use Dlookup in a query. The query does this by joining to lookup tables.

[CJ_London]

I would put the calculation as an addtional field in the form recordsource query - it will return either true or false. Then your expression becomes

[calcfield]=true

[FL0XN0X]

the Expression below is working in my subform (with name [Bezetting komende 7 dagen]).

DLookUp("[Klantenbestand].[Geboortedatum]";"[Klantenbestand]";"[Klantenbestand].[Naam kind]='" & [Forms]![Bezetting komende 7 dagen]![Naam_kind] & "'" & " AND [Klantenbestand].[Voornaam kind]='" & [Forms]![Bezetting komende 7 dagen]![Voornaam_kind] & "'")

What is the correct syntax to use it from within a mainform? (naam mainform = [Overzicht capaciteit])

[isladogs]

See if this info from Allen Browne helps: http://allenbrowne.com/casu-04.html

[ssanfu]

You should also remove ANY and ALL spaces in object names..... for example [Forms]![Bezetting komende 7 dagen]![Voornaam_kind]; there are spaces in the form name.

Then you have [Klantenbestand].[Voornaam kind]='" & [Forms]![Bezetting komende 7 dagen]![Voornaam_kind] & "'"))
In [Klantenbestand].[Voornaam kind], [Voornaam kind] does NOT have an underscore, but in other places in the query, [Voornaam_kind] DOES have an underscore.
Should check on that.....