J Jenn Jan 21, 2008 #1 I am trying to include 3 feilds in my report but exclude any blank entries in that report. How do I do this?
I am trying to include 3 feilds in my report but exclude any blank entries in that report. How do I do this?
J Jeff Boyce Jan 21, 2008 #2 Jenn Take a look at the Can Grow and Can Shrink properties of both those controls and the section within which they're located. NOTE: a blank (" "), a zero-length string (""), and a Null ALL look the same to casual human inspection. Are you quite certain you have "blanks"? -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/
Jenn Take a look at the Can Grow and Can Shrink properties of both those controls and the section within which they're located. NOTE: a blank (" "), a zero-length string (""), and a Null ALL look the same to casual human inspection. Are you quite certain you have "blanks"? -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP Microsoft IT Academy Program Mentor http://microsoftitacademy.com/
