I have a form that lists a person's demographic info. It's Record Source 

is a table that has a field called Extension - hold the 4-digit extension 

of the employee.



On the form, I want to have a field that displays the extension in the 

format of the entire phone number (123) 555- [the 4 digit extension].



I've tried every way I can think of using default values, & building a 

statement in that way - nothing works.



Help!



+Tammy

Tammy



Try putting "(123) 555-"; in the Format property of the control you're 

using to display the phone number.



-Brian



> I have a form that lists a person's demographic info. It's Record Source 

> is a table that has a field called Extension - hold the 4-digit 

extension 

> of the employee.

> 

> On the form, I want to have a field that displays the extension in the 

> format of the entire phone number (123) 555- [the 4 digit extension].

> 

> I've tried every way I can think of using default values, & building a 

> statement in that way - nothing works.

> 

> Help!

> 

> +Tammy

That's the easy part! =)  The problem is getting it to pull in the 

existing extension info. This box will be locked from any input, because 

the requiered value will already be there, & I don't want there to be an 

option to change it.



+Tammy



> Tammy

> 

> Try putting "(123) 555-"; in the Format property of the control you're 

> using to display the phone number.

> 

> -Brian

> 

> > I have a form that lists a person's demographic info. It's Record 

Source 

> > is a table that has a field called Extension - hold the 4-digit 

> extension 

> > of the employee.

> > 

> > On the form, I want to have a field that displays the extension in the 

> > format of the entire phone number (123) 555- [the 4 digit extension].

> > 

> > I've tried every way I can think of using default values, & building a 

> > statement in that way - nothing works.

> > 

> > Help!

> > 

> > +Tammy

Tammy,



There are a couple of ways to do this.  If the recordsource for the form

is a query, you can say PhoneNo:"(123) 555-" & [the 4 digit extension].

Then the control's Control Source would be PhoneNo.



Or



You can place a textbox on the for (txtPhone for clarity) and then:



Textbox name: txtPhone

Control Source: ="(123) 555-" & [the 4 digit extension]

Enabled: No

Locked: Yes



John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: brian.skelton@b...

[mailto:brian.skelton@b...] 

Sent: Thursday, November 29, 2001 4:57 PM

To: Access

Subject: [access] Re: VBA vs SQL to assign a default value





Tammy



Try putting "(123) 555-"; in the Format property of the control you're 

using to display the phone number.



-Brian



> I have a form that lists a person's demographic info. It's Record 

> Source

> is a table that has a field called Extension - hold the 4-digit 

extension 

> of the employee.

> 

> On the form, I want to have a field that displays the extension in the

> format of the entire phone number (123) 555- [the 4 digit extension].

> 

> I've tried every way I can think of using default values, & building a

> statement in that way - nothing works.

> 

> Help!

> 

> +Tammy

---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')



Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&catego

ryid=rn_ebooks

The form is based on a table, & it's pulling in the correct info from the 

table (so it appears! Although, it may just be displaying the name & SSN 

based on the command to pull that info from the previous form!).



I have the textbox in, & when I put that command for the Control Source 

all that shows in the (123) 555-



The table field is called Extension, so I put [Extension] after the & in 

the control source command; did I miss something?



+Tammy



> Tammy,

> 

> There are a couple of ways to do this.  If the recordsource for the form

> is a query, you can say PhoneNo:"(123) 555-" & [the 4 digit extension].

> Then the control's Control Source would be PhoneNo.

> 

> Or

> 

> You can place a textbox on the for (txtPhone for clarity) and then:

> 

> Textbox name: txtPhone

> Control Source: ="(123) 555-" & [the 4 digit extension]

> Enabled: No

> Locked: Yes

> 

> John Ruff - The Eternal Optimist :-)

Ok,



Do not name the textbox Extension as it will try to pull the data from

the Extension field.  Instead;



 Textbox name: txtExtension

 Control Source: ="(123) 555-" & [the 4 digit extension]

 Enabled: No

 Locked: Yes



John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: Tammy Tappan [mailto:GRTappan@e...] 

Sent: Thursday, November 29, 2001 6:39 PM

To: Access

Subject: [access] Re: VBA vs SQL to assign a default value





The form is based on a table, & it's pulling in the correct info from

the 

table (so it appears! Although, it may just be displaying the name & SSN



based on the command to pull that info from the previous form!).



I have the textbox in, & when I put that command for the Control Source 

all that shows in the (123) 555-



The table field is called Extension, so I put [Extension] after the & in



the control source command; did I miss something?



+Tammy



> Tammy,

> 

> There are a couple of ways to do this.  If the recordsource for the 

> form is a query, you can say PhoneNo:"(123) 555-" & [the 4 digit 

> extension]. Then the control's Control Source would be PhoneNo.

> 

> Or

> 

> You can place a textbox on the for (txtPhone for clarity) and then:

> 

> Textbox name: txtPhone

> Control Source: ="(123) 555-" & [the 4 digit extension]

> Enabled: No

> Locked: Yes

> 

> John Ruff - The Eternal Optimist :-)

---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')



Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&catego

ryid=rn_ebooks

I didn't - the text box is called txtUsersPhone.



??



+Tammy





> Ok,

> 

> Do not name the textbox Extension as it will try to pull the data from

> the Extension field.  Instead;

> 

>  Textbox name: txtExtension

>  Control Source: ="(123) 555-" & [the 4 digit extension]

>  Enabled: No

>  Locked: Yes

> 

> John Ruff - The Eternal Optimist :-)

> 

> 

Ok Tammy,



Then set the Control Source, Enabled, and Locked to what I've indicated

below.





Textbox name: txtUsersPhone

Control Source: ="(123) 555-" & [the 4 digit extension]

Enabled: No

Locked: Yes



John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: Tammy Tappan [mailto:GRTappan@e...] 

Sent: Thursday, November 29, 2001 8:30 PM

To: Access

Subject: [access] Re: VBA vs SQL to assign a default value





I didn't - the text box is called txtUsersPhone.



??



+Tammy





> Ok,

> 

> Do not name the textbox Extension as it will try to pull the data from



> the Extension field.  Instead;

> 

>  Textbox name: txtExtension

>  Control Source: ="(123) 555-" & [the 4 digit extension]

>  Enabled: No

>  Locked: Yes

> 

> John Ruff - The Eternal Optimist :-)

> 

> 



---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')



Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&catego

ryid=rn_ebooks

Did that except the info inside the [ ] for me is [Extension], which is 

the field name I'm pulling from.



Textbox name: txtUsersPhone

Control Source: ="(123) 555-" & [Extension]

Enabled: No

Locked: Yes



Do you think the form isn't linking to the table?



+Tammy



> Ok Tammy,

> 

> Then set the Control Source, Enabled, and Locked to what I've indicated

> below.

> 

> 

> Textbox name: txtUsersPhone

> Control Source: ="(123) 555-" & [the 4 digit extension]

> Enabled: No

> Locked: Yes

> 

> John Ruff - The Eternal Optimist :-)

>