If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting phone field based on value in another field
I'm trying to format a field that contains a phone number on a split form.
If the value in the Country/Region field is equal to the value "USA" I want the phone field to format as (@@@) @@@-@@@@. If the value is equal to any other country abbreviation I want to display whatever the value is without formatting. I'm using the following in the Control Source for the phone number field, but it's generating #Name? values. =IIf([Country/Region]="USA",Format([Business Phone],"(@@@) @@@-@@@@"),[Business Phone]) Any idea what I'm doing wrong here? Ken |
#2
|
|||
|
|||
Formatting phone field based on value in another field
On Thu, 15 Apr 2010 15:25:01 -0700, Ken Warthen
wrote: The error seems to indicate that either [Country/Region] or [Business Phone] is not the name of a field in the underlying data set. Otherwise your expression looks good. -Tom. Microsoft Access MVP I'm trying to format a field that contains a phone number on a split form. If the value in the Country/Region field is equal to the value "USA" I want the phone field to format as (@@@) @@@-@@@@. If the value is equal to any other country abbreviation I want to display whatever the value is without formatting. I'm using the following in the Control Source for the phone number field, but it's generating #Name? values. =IIf([Country/Region]="USA",Format([Business Phone],"(@@@) @@@-@@@@"),[Business Phone]) Any idea what I'm doing wrong here? Ken |
Thread Tools | |
Display Modes | |
|
|