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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment