Monday, December 21, 2009

MS Access: How to create a Report based Input Mask that puts text before field data?

I want the word ';Month: '; to appear before the data that is in a field (only if it's not null). How to I format the Input Mask? Thank you!MS Access: How to create a Report based Input Mask that puts text before field data?
Use a TEXTBOX with an IIF statement instead of a mask:





=IIF([Month] is not null, ';Month: ';%26amp; [Month], ';'; )





In Access Queries and Reports IF is spelled with 2 ';i';s.

No comments:

Post a Comment