Input mask in a report

[timark]

Hi,
I have a field which has input mask but when I print preview in a report. Its does not appear the whole field.

 

[vbaInet]

Increase the width and/or the height of the box and Bring It To Front.

 

[timark]

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.

 

[SOS]

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

 

[timark]

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

 

[SOS]

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.