>>>I want to clear textbox controls after fill out a form for filling out the same form again but with textbox controls cleared.
>>>what do I have to do?
>>Hi Alberto.
>>
>>Are the textboxes on the form bound to a table? Are you adding a new record to the table? If so, try thisform.Refresh() after you append blank. If the textboxes aren't bound, you will have to go through something like:
>>
>>for lni = 1 to thiform.controlcount
>> thisform.controls[i].value = ""
>>endfor
>>
>>Of course, this only works if all the controls have values that are character. You really should check for type(thisform.controls[i]) and take appropriate action in a case statement. And thisform.refresh() afterward.
>>
>>Marcia
>
>Unfortunately this will set all of your labels to '' also :-( If your controls are bound, then add a blank record as Dave Johns suggested. If they are unbound, then have a form method which sets the value of each textbox in turn and then calls a form refresh.
>
>HTH
>Barbara
Hi Barabra.
Whoops! Forgot about the labels:-) Thanks.
Marcia
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only