Ms-access – how to clear text box inside a macro

ms-access

I have a macro for onclick event for a combo, how do i have something to clear the text box in the same form when the user click on combo box and make selection. I would like to do the clear inside the same macro rather than a procedure.

Best Solution

Not clear what you mean by macro? Do you mean the new macro language in Access, or do you mean VBA code?

In VBA code you can just go:

Me.MyComboBox = null

In macro code, you use SetProperty, input the name of your Control, set the Property to "Value" and just leave the Value blank.

Related Solutions

Ms-access – reading a text file in ms access

Here's an example of how to open a text file and copy a field into a field on your form

Dim MyStr1 as string
dim MyStr2 as string

Open "TESTFILE" For Input As #1
Do While Not EOF(1)    ' Loop until end of file.
    Input #1, MyStr1, MyStr2
    me.txtStr1 = MyStr1
    me.txtStr2 = MyStr2
Loop
Close #1    ' Close file.

(the example loops through multiple rows, but you could equally well unroll the loop and do each row individually, as you might want to do - depending on how your text file is organised)

You can find more info here

Best Solution

Related Solutions

Ms-access – reading a text file in ms access

Related Question