Clearing a Textbox

**JaredM** · Dec 14th, 2001, 09:29 AM

Is there a way to clear a textbox other than.

Text1.text = ""

**abdul** · Dec 14th, 2001, 09:47 AM

You can also use API like this:

VB Code:

Private Declare Function SetWindowText Lib "user32" Alias "SetWindowTextA" (ByVal hwnd As Long, ByVal lpString As String) As Long
SetWindowText Text1.hwnd, ""

**JaredM** · Dec 14th, 2001, 09:50 AM

That's a bit much. What I was trying to hit at was if there is a function that can clear a textbox, because this form I have in Access acts funny when I clear the two date formatted text boxes with = "".

**FATBOYPEE** · Dec 14th, 2001, 09:57 AM

Are your textboxes bound or unbound ?

If they're unbound, you should have no problems ?

Pee

**Hack** · Dec 14th, 2001, 10:01 AM

What do you mean by "acts funny"?

**JaredM** · Dec 14th, 2001, 10:15 AM

It sings and it dances.

It causes errors what else?

**FATBOYPEE** · Dec 14th, 2001, 10:23 AM

ooooh !

Instead of assigning a format to the textbox (assuming you have?), put some formatting on the values in code in the lostfocus event or somesuch....

You can then trap any errors that arise from the data not being validat against the Access Format.

Pee

**MrGTI** · Dec 14th, 2001, 10:33 AM

Just a suggestion, .... but you'd be better off by putting all your code into a VB form, and leaving the Access database to just be a database.

**da_silvy** · Dec 14th, 2001, 10:35 AM

perhaps this project is only access.

what about

text1 = ""

or

text1 = vbnullstring

might work

**MrGTI** · Dec 14th, 2001, 10:43 AM

In Access you have to set the FOCUS to the textbox before you can clear it.

I'm just saying, .... to avoid headaches down the road, make it in VB. Maybe he can't. It's just a suggestion.

**JaredM** · Dec 14th, 2001, 10:46 AM

Goes to show how much you know about Access.

You don't need to set the focus. Only when you use the text property do you need to use the setfocus().

Just clear textboxes like

Text1 = ""

And this is in Access 97, I'm working for a company and they do not have VB compilers.

**FATBOYPEE** · Dec 14th, 2001, 10:59 AM

Originally posted by JaredM
Goes to show how much you know about Access.

Hmm, how to win friends and influence people !!

Well, nice to know any suggestions & help are appreciated....

**MrGTI** · Dec 14th, 2001, 11:10 AM

Yeah really huh? Go figure.

I could be mean and say something about "VB compilers", but i'm not going to.

**JaredM** · Dec 14th, 2001, 12:32 PM

I was kidding. Maybe I should've put a smiley next to it.

I figured out the problem. I had to set the formatting property on the textbox in access in addition to the input mask.

DaoK · Dec 14th, 2001, 12:34 PM

That work :

VB Code:

Option Explicit
Private Sub Form_Load()
Dim Clear As String
Text1 = Clear
End Sub

**Hack** · Dec 14th, 2001, 03:23 PM

But, doesn't Clear contain "" which is what he is trying to avoid?

**JaredM** · Dec 14th, 2001, 03:31 PM

Don't worry peeps I've got it to run properly now. Course it's a little bit cheesy, but the end user won't be able to see it going on.

**Hack** · Dec 14th, 2001, 03:43 PM

As long as it works.

What did you do? I'm curious.

DaoK · Dec 14th, 2001, 03:59 PM

But, doesn't Clear contain "" which is what he is trying to avoid?

I know that but he wanted to avoid the "" so a empty variable is equal to "" but you do not see it... Anyways, I do not see what is wrong with "" .

**da_silvy** · Dec 14th, 2001, 07:58 PM

what's the point of 4 lines if you can do it in 1?

text1 = ""

that will work the same, if not better than your little (big) example

**JaredM** · Dec 18th, 2001, 08:29 AM

There was a property called FORMAT in the textbox control for Access. I threw in the proper formatting and the problem went away.

Thread: Clearing a Textbox

Thread Tools

Display

Clearing a Textbox

Posting Permissions