SEPERATING NUMBERS

ALAN

Registered User.
Local time
Today, 00:45
Joined
Jul 12, 2000
Messages
23
My Identifiction number field have 12 numbers. It is entered in one row by the users. I want to seperate the number to 6 - 2 - 4. For eg. 680572081553. I want to change it to 680572-08-81553 in report.
 
If you are only concerned with the data display format on Reports you might print using this number then you should just have to set the Format property of the field to something like...

000000-00-0000

should work.
Just as an aside, generally speaking if you do not intend to do any math with numbers that you store in your DB, then it is best to store then as text. You have more flexability with strings. So I would store your Id numbers in Text fields if you can.
Good Luck
Chris
 

Users who are viewing this thread

Back
Top Bottom