Text box keeps data on every record

O

oxicottin

Hello, I have a text box thats format is standard with no defualt value. When
I enter data into this text box and advance to the next record the data is
still there. How do I fix this?

Thanks,
Chad
 
B

Brendan Reynolds

It sounds like the text box is unbound, that is to say, doesn't have the
name of a field in the underlying table or query as it's Control Source
property. If you want the data saved in the table, you'll want to put the
name of the field in there. If you want the text box to remain unbound, but
you want it to be blanked out when the user moves to a different record, add
the following line of code to the Current event procedure of the form ...

Me!NameOfYourTextBoxHere = Null
 
O

oxicottin

Yes I forgot to mention it was unbound!! I have another question? I have a
text box and for the life of me I cant remember what setting I had to select
in the text box properties to make it be able to enter in the box and move
down a line instead of tabing all over the place.

Thanks,
Chad
 
B

Brendan Reynolds

My best guess is that you may be looking for the 'Move after enter' option,
but this is not a property of individual text box controls, it's an Access
setting that you'll find in the Options dialog. From the Tools menu, Choose
Options, and in the Options dialog, choose the Keyboard tab.
 
C

Colin

Sorry Brendan, but I'm a newbie to Access :-/ I have an unbound text box
called Notes which does the same as described. Do I use 'Notes = Null' and
where do I put this?
 
J

John W. Vinson

Sorry Brendan, but I'm a newbie to Access :-/ I have an unbound text box
called Notes which does the same as described. Do I use 'Notes = Null' and
where do I put this?
Click to expand...

Data is NOT stored in textboxes, and it is NOT stored in forms.

A Form *is just a window*. Data is stored in tables, and only in tables. An
unbound textbox on a form is like a picture painted on a windowpane - the
sunflowers and bluebirds are still there whether it's sunny or dark, summer or
winter outside. <g>

If you want to keep the note - especially if you want to keep the note in
conjunction with other data entered on the form - then you must create a Notes
field (Memo datatype I'd guess) in your Table, and bind the textbox to that
field.

John W. Vinson [MVP]
 
C

Colin

Ah, of course. Initially I did have it in the table, but the number of
characters was restricted. Changing the datatype to Memo was the answer. Many
thanks for the quick response :)
 
Top