return field vaule with records greater that 6 charaters

[aussiehedge]

I would like to retur these records only if they have more that 6 charaters

Like [Forms]![Class1]![Subheading Query subform].[Form]!

& "*"​

 

[John Big Booty]

You could try;

[URL="http://www.techonthenet.com/access/functions/string/len.php"]Len[/URL]([Forms]![Class1]![Subheading Query subform].[Form]![heading]) > 6