phone number format

[beth]

I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[Wayne-I-M]

Can you give a few examples of a cell phone number (that you want to display)
and some "non" cell phone numbers (that you don't want to display)

 

[John Spencer]

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[beth]

I need to display any number that appears in the table in a std format (area
code) ###-####. This is for a membership directory and will eventually go up
on the website and directly to a printer. So if no one gave me a cell no or a
fax no I don't want the label to be displayed on the report. I can get the
info to appear when I want I just can't maintain the input mask format.

Can you give a few examples of a cell phone number (that you want to display)
and some "non" cell phone numbers (that you don't want to display)


--
Wayne
Manchester, England.

I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[beth]

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[beth]

I finally got it-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for being there again!

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[Klatuu]

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[beth]

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[Klatuu]

I thought you said you did not want Cell: to show if there is no number. As
you have it written, it will show. Also, I would not trust your Len = 10
test.
--
Dave Hargis, Microsoft Access MVP

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

:

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[beth]

I don't want cell to show, I used + not &. I printed it and it looks the way
I want, but will the len 10 be a problem when I save HTML

I thought you said you did not want Cell: to show if there is no number. As
you have it written, it will show. Also, I would not trust your Len = 10
test.
--
Dave Hargis, Microsoft Access MVP

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP


:

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

:

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[Klatuu]

No, but that is not the real issue. The problem lies in a user entering a
phone number with no area code or with missing digits. What you have will
probably be just fine, but I ususally check for the exsitance of data rather
than a specific length of a field except when the length of the field has
meaning.
--
Dave Hargis, Microsoft Access MVP

I don't want cell to show, I used + not &. I printed it and it looks the way
I want, but will the len 10 be a problem when I save HTML

I thought you said you did not want Cell: to show if there is no number. As
you have it written, it will show. Also, I would not trust your Len = 10
test.
--
Dave Hargis, Microsoft Access MVP

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

:

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP


:

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

:

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[beth]

That makes sense, since I'm the one entering all the data with numb fingers.
I'll go back and fix it.
One more question if you can. I'm super new to trying to put info into web
sites. My access report is 13 pages long. How do I export it to the web as
one running page?

No, but that is not the real issue. The problem lies in a user entering a
phone number with no area code or with missing digits. What you have will
probably be just fine, but I ususally check for the exsitance of data rather
than a specific length of a field except when the length of the field has
meaning.
--
Dave Hargis, Microsoft Access MVP

I don't want cell to show, I used + not &. I printed it and it looks the way
I want, but will the len 10 be a problem when I save HTML

I thought you said you did not want Cell: to show if there is no number. As
you have it written, it will show. Also, I would not trust your Len = 10
test.
--
Dave Hargis, Microsoft Access MVP


:

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

:

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP


:

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

:

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[Klatuu]

Sorry, beth, I don't know the anwer to that. I have never done it.
I suggest you post a brand new question on that.
--
Dave Hargis, Microsoft Access MVP

That makes sense, since I'm the one entering all the data with numb fingers.
I'll go back and fix it.
One more question if you can. I'm super new to trying to put info into web
sites. My access report is 13 pages long. How do I export it to the web as
one running page?

No, but that is not the real issue. The problem lies in a user entering a
phone number with no area code or with missing digits. What you have will
probably be just fine, but I ususally check for the exsitance of data rather
than a specific length of a field except when the length of the field has
meaning.
--
Dave Hargis, Microsoft Access MVP

I don't want cell to show, I used + not &. I printed it and it looks the way
I want, but will the len 10 be a problem when I save HTML

:

I thought you said you did not want Cell: to show if there is no number. As
you have it written, it will show. Also, I would not trust your Len = 10
test.
--
Dave Hargis, Microsoft Access MVP


:

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

:

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP


:

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

:

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.

 

[beth]

After a break, I'll start a new post. Thanks for all of your help.

Sorry, beth, I don't know the anwer to that. I have never done it.
I suggest you post a brand new question on that.
--
Dave Hargis, Microsoft Access MVP

That makes sense, since I'm the one entering all the data with numb fingers.
I'll go back and fix it.
One more question if you can. I'm super new to trying to put info into web
sites. My access report is 13 pages long. How do I export it to the web as
one running page?

No, but that is not the real issue. The problem lies in a user entering a
phone number with no area code or with missing digits. What you have will
probably be just fine, but I ususally check for the exsitance of data rather
than a specific length of a field except when the length of the field has
meaning.
--
Dave Hargis, Microsoft Access MVP


:

I don't want cell to show, I used + not &. I printed it and it looks the way
I want, but will the len 10 be a problem when I save HTML

:

I thought you said you did not want Cell: to show if there is no number. As
you have it written, it will show. Also, I would not trust your Len = 10
test.
--
Dave Hargis, Microsoft Access MVP


:

I got it with this-
="Cell: "+IIf(Len([CP])=10,Format([CP],"(000) 000-0000"),[CP])
Thanks for everyone's help

:

You have a syntax error and Cell: will be displayed regardless of whether
there is number in the field or not. If you use John's suggestion with a
Format added, I think it will get you what you want:
= IIF(Len([CP] & "") > 0, "Cell: " & Format([CP],"(000) 000-0000"),Null)

--
Dave Hargis, Microsoft Access MVP


:

This is the base I started with, then added & deleted commas and parenthese
="Cell:" = [CP],format([CP], "(000) 000-0000)

:

It would help if you posted what you tried.

The following expression should work.

= IIF(Len([CP] & "") > 0, "Cell: " & [CP],Null)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

beth wrote:
I'm using a combined value text box for a cell phone number.
="Cell:" + [CP] , I can't keep the formating from the table. I've tried
using a similiar format that I received last week concerning a zip code
format, but I get syntex error or 'missing comma or paranthese.
The goal here is to specify that this phone is a cell phone since it
displays right next to a home phone, but I don't want Cell to show if there
isn't one.
Any help is appreciated.