format SSN

DAPPLE

Registered User.
Local time
Today, 03:14
Joined
Apr 11, 2002
Messages
73
How do I format the field to show number as a SSN with dashes?

Please and Thank You!
 
If you want to do this in a table, you have to go to the design of your table and click on the input mask and the wizard will take you thruogh the steps. Or you can put this in the field where it says input mask:
000-00-0000;0;_
this will do it too:)
 
THANKS SO MUCH!
 
I HAVE TWO - THREE BLANK PGS BETWEEN EACH RECORD ON MY REPORT WHEN I PRINT IT. IS THAT BECAUSE I SET IT UP WITH A SUBREPORT, AND IT AUTOMATICALLY ALLOWS 5 PGS OF CHILD INFO (BLANK IF NONE) PR PARENT ??
 
Make sure you set your subrepot's can shrink and grow properties correctly. Also make sure you don't have extra spaces on the side and the bottom of your report. Reports are very tricky. It took me along time to get the hang of it with just experimentation!

By the way, this was a different question from your original one and you should have asked it seporately!

Anyway, try that and see if it works!
 

Users who are viewing this thread

Back
Top Bottom