Clear Textboxes except one

Note also that instead of

Set ctrl.Value = ""
 Use

Ctrl.Value = Null   '  Not a good idea to set to a zero length string.

mx

DatabaseMX;
I got an error here
ctrl.Value = Null  ' change here
Error 2448
Can not assign a value to this object

Are the text boxes bound to a certain recordset?

"Can not assign a value to this object "

Probably because that control has a Calculated control source, like

=<SomeExpression>

?

In this case, you'll need to remove that calculated control before you can clear it. However, I assume that you want to place more values in the boxes later?

The textboxes are use to show a top5 from a recordset, but when I use the simple textbox = it works. This  particular combox Im running the code from is a small table I use to let user choose the criteria for the recordset filling the textboxes.
Al I need to do is clear all the textboxes before I run the code to fill them with the records set values.
Im filling these with a top5 but sometimes the top5 query may return less than 5 so I need to clear them before run the code again&
No calculated fields

It works!, can you explain why?

thanks!

Well, It's basically ignoring that error you are getting ... which I can emulate IF ... I make a one of the controls a calculated control.  Not sure what is going on in your case however.

mx

" Not sure what is going on in your case however."
That is the reason I was asing why it work...or in anohter words why it didnt work before clearing the error. So I should be looking for a textbox (got like 30) that may be rising a calculated field? if the records set is only filling the textboxes why will it be a calcuated field? I got 2 that take a date can this be anohter reason for hte error?

Why the grade of B ?

MX, we are just ignoring the error, and not finding with a complete solution..I think I needed to probably prove more information..

Well, w/o seeing your mdb ... and if you say there are no calculated text box controls, then I don't know off hand what else would result in "Can not assign a value to this object ".

"Author Comments:
" Not sure what is going on in your case however."
That is the reason I was asing why it work...or in anohter words why it didnt work before clearing the error. So I should be looking for a textbox (got like 30) that may be rising a calculated field? if the records set is only filling the textboxes why will it be a calcuated field? I got 2 that take a date can this be anohter reason for hte error?"

>>"So I should be looking for a textbox (got like 30) that may be rising a calculated field?"

Are you positive there are no text boxes with calculated controls?  That is about the only reason that error would occur, so ...  I used the On error Resume Next.

mx

DatabaseMX:
First of all I want to apologized for not following your instructions correctly;
I keep looking for calculated fields in the form until I found 5! I went one by one in the immediate window unit I came across the value of what I thought I had a label caption (as a title of s subcategory ) as title BUT it was a textbox with a = "(" & top5FirstIssue_TXT.Value & ")" So here is the calculated field!
You were right if you dont have the Db you can debug it, so it was my fault not provide all the right information.
This form had a top5 (5 txtboxes) and the top5 of the top5 (25txt's more) and the titles of these subcategories...you understand mess trying to populate these with a recorset.
DbMX I take my hat again and I evaluate you help as an A+
Thanks
IgnBan

no problem.  It's good to know that WAS the cause of the error.

mx