How to display - (dash)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the format property of the control. The format should probably be

@@@@@-@@-@@@-@

That assumes that acct_no is a text field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show records from diff table 3
Input data in two tables 6
Formatting a cell - remove a dash 5
DSum problems 5
display report from a form with subforms 1
Display in Report 1
Problem With Text & number format 1
Displaying dashes from table 1

Back
Top