Formatting Table Field Question

  • Thread starter Thread starter rexirae
  • Start date Start date
R

rexirae

Hello,
I have a field that stores phonenumbers. The phonenumbers are
usually seven digits long but if there is more than one line the digits are
8. For example:

PhoneNo:1234567 and PhoneNo2:1234756-9 (which means line 756 to line 759).

Now I would like to format the field so that a dash is displayed when there
are more than 7 digits and that nothing is displayed if there are only 7
digits.
So far I've managed to get this format in my fields:
Phone No:1234567- and PhoneNo2:1234756-9

Any suggestions?
Thanks in advance
 
Your "phoneNo2: 1234756-9" is not a phone number -- you couldn't dial that
and expect to get a connection. It sounds like you've tried to add more
than one fact into one field. Some of your "phoneno" fields hold a single
phone number, and some hold a string that indicates, if you know what it
means, multiple phone numbers. This goes against one of the basic notions
of normalization.

Why not use multiple records in your tblPhone to depict multiple lines?
What? You don't have a tblPhone?! (I hope you do, as you've described a
one-to-many relationship - one "something" can have many phone lines.).
 
Back
Top