G Guest Jan 19, 2006 #1 I hv field name [acct_no]. Say the data is 14000123456 and i want it to appear as 14000-12-345-6 in my report. Appreciate your help
I hv field name [acct_no]. Say the data is 14000123456 and i want it to appear as 14000-12-345-6 in my report. Appreciate your help
J John Spencer Jan 19, 2006 #2 Use the format property of the control. The format should probably be @@@@@-@@-@@@-@ That assumes that acct_no is a text field.
Use the format property of the control. The format should probably be @@@@@-@@-@@@-@ That assumes that acct_no is a text field.