Input mask in a report

timark

Registered User.
Local time
Today, 22:19
Joined
Feb 16, 2010
Messages
17
Hi,
I have a field which has input mask but when I print preview in a report. Its does not appear the whole field.
 
Increase the width and/or the height of the box and Bring It To Front.
 
Increase the width and/or the height of the box and Bring It To Front.

Pardon me for not expressing myself clearly. I am referring to one of the field from my table.(Eg:Tel field which I had input mask of ABC-999-999. When I pull out this field in my report, it does not generate ABC.

How should I allow the ABC to appear in my reports?

Thanks.
 
INPUT masks are for INPUT only. Not for DISPLAYING data. Use the FORMAT property of the control instead.
 
INPUT masks are for INPUT only. Not for DISPLAYING data. Use the FORMAT property of the control instead.

Hi, dun quite get you as my knowledge of access is not that good. Could u pls elborate more.

Thanks
 
If you open the report in design view and move what you had in the Input Mask to the control's FORMAT property it should work.
 

Users who are viewing this thread

Back
Top Bottom