Change the value of a text box in Form

  • Thread starter Thread starter emerlita
  • Start date Start date
E

emerlita

Hi.

I have a textbox named PseudoCLLI that and i want this Auto-generated
suggested value equal to the ShortCLLI. How do i do this? PLUS, it is
suggested meaning i can overwrite what's there.
 
Hi.

I have a textbox named PseudoCLLI that and i want this Auto-generated
suggested value equal to the ShortCLLI. How do i do this? PLUS, it is
suggested meaning i can overwrite what's there.
Click to expand...

In the AfterUpdate event of the ShortCLLI TextBox...

Me.PseudoCLLI = Me.ShortCLLI
 
Open your table in design view. Select the field that the textbox PseudoCLLI
represents. In the bottom section enter "ShortCLLI" for the default value.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Open your table in design view. Select the field that the textbox PseudoCLLI
represents. In the bottom section enter "ShortCLLI" for the default value.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)







- Show quoted text -
Click to expand...

both of these suggestions didn't work.
In the table, still shows blank entries in PseudoCLLI.
In Form, same, still blank.
 
You did not do something right! What is the controlsource of your textbox
PseudoCLLl? Is it a field in your table? Did you enter "ShortCLLl" as the
default value of that field in your table?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
You did not do something right! What is the controlsource of your textbox
PseudoCLLl? Is it a field in your table? Did you enter "ShortCLLl" as the
default value of that field in your table?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)







- Show quoted text -
Click to expand...

OK, now it works except for when i changed the PseudoCLLI, this
changes the ShortCLLI too.
What i exactly want to do is have it this way(above) but when i try to
change the PseudoCLLI, shouldn't change the ShortCLLI at all and they
won't have the same value after the pseudoCLLI changed. The first
event applies only when the PseudoCLLI don't get overwritten.
Hope this makes sense.
 
You don't need the code. Just set the default value for the PseudoCLLl
field.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Open your table in design view. Select the field that the textbox PseudoCLLI
represents. In the bottom section enter "ShortCLLI" for the default value.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)







- Show quoted text -
Click to expand...

OK. now, i took out the code out and tried to add the default Value as
"=ShortCLLI" but this one gives me "ShortCLLI" as the actual value of
my PseudoCLLI.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable To Read Value in Masked Textbox 1
Formatting phone field based on value in another field 1
Display of numerical value with decimals in a text box 5
Choose a value from a combo box based on a text box 0
Access 2 Digit year in Access Text Box 3
Capture initial value of text box 3
auto populate text box based on combo box value 1
Auto-Fill Text box on form 4

Back
Top