467,921 Members | 1,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

Make TextBox Editable.

100+
Hi,
My project is in MS Access.
In which I have one Form(DatEntry) which I am using for data entry in table(PRODUCTION).
In this Form I have some Textboxes and Comboboxes.
Date,PalletNo,CustomerCode,ItemNo,PONo,Desc,Carton s,Pcs,PartialCarton,PartialCarton1,PartialCarton2, TotalQuantity,Notes.
All are of type Text.
Now when I enter Cartons and Pcs in the TextBoxes after that Total Quantity will automatically count and value of Textbox(TotalQuantity) set to its value.After that when I enter some quantity in Partial Carton Textbox then again TotalQuantity change.
For this I am Using Code as the control source of TotalQuantity TextBox.

=(([Cartons_Text]*[PcsOrCarton_Text])+[PartialCarton_Text]+[PartialCarton1_Text]+[PartialCarton2_Text])

Now sometimes in rear cases I have to put some words like PPK instead of numbers in PartialCarton,PartialCarton1,PartialCarton2.
So at that time this code isn't working.
So I have to manually enter the Value in TotalQuantity Textbox.

But I change the property of TotalQuantity Textbox and set No to Enabled so no one can change it.
But now I want to change in back to normal but still I can't change the value of TotalQuantity Textbox.

I remove the code from the control source property of TotalQuantity Textbox and already try the code in the AfterUpdate event of PartialCarton but its not working.

Private Sub PartialCarton_Text_AfterUpdate()
TotalQuantity_Text=[Cartons]*[Pcs]
TotalQuantity_Text.Enabled = True
End Sub

Even I try to put new Textbox.But when I run the project I can't change the value of it either.it will automatically set the No to Enabled property of new textbox.

I don't know what is going on?
Somebuddy Plz help me.Otherwise I have to design the whole form again.

Thanks.
Dec 18 '07 #1
  • viewed: 4736
Share:
2 Replies
Rabbit
Expert Mod 8TB
When you set the control source of a control to an expression, that control is no longer editable.
Dec 18 '07 #2
100+
Thanks for ur reply.
I was making something impossible possible.
But now I got my answer.
Thank You.
Dec 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by george d lake | last post: by
3 posts views Thread by Angela Chen | last post: by
4 posts views Thread by John Smith | last post: by
6 posts views Thread by rn5a | last post: by
2 posts views Thread by rn5a | last post: by
4 posts views Thread by Steve Kershaw | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.