By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,532 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

Make TextBox Editable.

100+
P: 101
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
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,396
When you set the control source of a control to an expression, that control is no longer editable.
Dec 18 '07 #2

100+
P: 101
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.