Search results for query: *

yes : in the properties of the text box there is a property: "Scoll bars" you can choose vertical Horizontal both none also if this is going to be a multiple line field you maigh want to change the "enter key behavior" property to "new line in field"

Actually, this shouldn't happen like that. what command are you using to move to the new record? try using this: DoCmd.GoToRecord , , acNewRec also are you in form view

Can you bring up a debug window and see where the error is happening. I got something simmilar to that when i closed a form, some part of the code was still running and it couldn't find its needed controls, so i just put an on error statement in the beginning of the code. But you'll need to...

the answer to your #1: set the Default value property to =Date()

I am assuming that you want to open a recordset containing records that have a date between (for example) Jan 3(03/01) and Mar 6(06/03) with no year: Also I assume that in your Table [year end] is a string that is of the format "01/02" (1 feb) *NOTE: this is not US date format of...

change the line If str(key_number) = key_find Then Exit Do to If key_number = val(key_find) Then Exit Do so tit will work sorry

this is one way to do it, sorta bad, but works if you dont have too many records. On your form make a text box and name it: key_find do not give it a control source also make sure you have a text box named key_number that has a control source of key number on the key_find text box properties...

Hey, I have a suggestion. This is a text box control on a form, right, in "control source" you have =[myfield] & "TEXT" make sure that "Name" (of the text box control) is not myfield or chage the "control source" to =[myquery].[myfield] &...