ACCESS 2010 DLookup and Left Trim

[bamptontowers]

I am trying to use DLOOKUp and Trim in a calculated control on a form - D look up works but when i add Left trim to trim a telephone number to just the prefix - it wont work



=DLookUp("[CSP]","[Csp_Codes]","[Data] = '" & [Forms]![Application_Frm]![CommsData_tbl subform].[Form]![Data] & "'") - Works OK
=DLookUp("[CSP]","[Csp_Codes]","[Data] = '" & [Forms]![Application_Frm]![CommsData_tbl subform].[Form],7) & "'") - appears to put square brackets around Left ??

Any help appreciated

Dave

[pbaldy]

The two functions would go around the entire form reference, not just the last bit.

[bamptontowers]

The two functions would go around the entire form reference, not just the last bit.

Can you explain what ive left out - Thanks

[pbaldy]

Left(Trim([Forms]![Application_Frm]![CommsData_tbl subform].[Form]![Data]), 7)

[bamptontowers]

Left(Trim([Forms]![Application_Frm]![CommsData_tbl subform].[Form]![Data]), 7)

Thank You its works a treat

Dave

[pbaldy]

No problem Dave, and welcome to the site by the way!