By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,478 Members | 1,374 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,478 IT Pros & Developers. It's quick & easy.

how can i make unbound box limit to one line

P: n/a
Dear Access Programmers,

I can't seem to figure this out.

The text boxes that are used to input data via my form are
unbound, I want to restrict the user to only put input that
is one line.

Eg.

Input your surname., you shouldn't be able to press the
enter/return key after since it will take the user to the next
line and the infomation will dissapear in the form box since
its a new line, thus you would have to backup to get the
data back.

How can I limit the data entre to one liners ? is there a simply
way ?

******
Seconly, how come I can't seem to get my toolbox, field list
to show ? I enter the forms and press the design view, but
can't seem to have any other views ? Is there a special key
I can press or what?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
There should be buttons on the Design View toolbar that will open up the
Toolbox and Properties sheet.

To prevent the Enter key, in the KeyDown event

If KeyCode = 13 Then KeyCode = 0

--
Wayne Morgan
Microsoft Access MVP
"Earthling" <in******@earthplanet09087.com> wrote in message
news:k9******************@twister01.bloor.is.net.c able.rogers.com...
Dear Access Programmers,

I can't seem to figure this out.

The text boxes that are used to input data via my form are
unbound, I want to restrict the user to only put input that
is one line.

Eg.

Input your surname., you shouldn't be able to press the
enter/return key after since it will take the user to the next
line and the infomation will dissapear in the form box since
its a new line, thus you would have to backup to get the
data back.

How can I limit the data entre to one liners ? is there a simply
way ?

******
Seconly, how come I can't seem to get my toolbox, field list
to show ? I enter the forms and press the design view, but
can't seem to have any other views ? Is there a special key
I can press or what?

Nov 12 '05 #2

P: n/a
"Earthling" <in******@earthplanet09087.com> wrote in message news:<k9******************@twister01.bloor.is.net. cable.rogers.com>...
Dear Access Programmers,

I can't seem to figure this out.

The text boxes that are used to input data via my form are
unbound, I want to restrict the user to only put input that
is one line.

Eg.

Input your surname., you shouldn't be able to press the
enter/return key after since it will take the user to the next
line and the infomation will dissapear in the form box since
its a new line, thus you would have to backup to get the
data back.
Any reason why your fields are unbound? (You like making work for
yourself?) You could set the field's length in the underlying
table... or I guess you could use the keypress event or something to
check the length of the entry and then set the keyascii value to zero
for every subsequent keypress in that field...
How can I limit the data entre to one liners ? is there a simply
way ?

******
Seconly, how come I can't seem to get my toolbox, field list
to show ? I enter the forms and press the design view, but
can't seem to have any other views ? Is there a special key
I can press or what?


Whoa, wait a minute. If your form in UNBOUND, then of course you
can't get a list of fields. Think about it - the field list is a list
of fields that are in the recordsource for the form. And that
*necessarily* means that the form is bound. Yours isn't, so you have
no fields in your field list. You want fields listed? Bind your
form.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.