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

Line Return

P: n/a
Is it possible to enter a line return into any other field other than text (such
as number, currency or date/time)?

How can a user be prevented from entering a line return into a field?

Thanks!

Mark

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies

P: n/a
Mark wrote:
Is it possible to enter a line return into any other field other than text (such
as number, currency or date/time)?

You could have just tried it.

Numeric and DateTime fields will not accept a new line.

--
Marsh
MVP [MS Access]
Nov 12 '05 #2

P: n/a
Marsh,

I appreciate you responding to my post!

I did try it before posting and found what you said. However, it's important
enough that I wanted an independent confirmation. I assume you regard a currency
field as a numeric field.

Can you respond to the second question in my post ----
<<How can a user be prevented from entering a line return into a field?>>

Thanks!

Mark

"Marshall Barton" <ma*********@wowway.com> wrote in message
news:pm********************************@4ax.com...
Mark wrote:
Is it possible to enter a line return into any other field other than text (suchas number, currency or date/time)?

You could have just tried it.

Numeric and DateTime fields will not accept a new line.

--
Marsh
MVP [MS Access]

Nov 12 '05 #3

P: n/a
If you position your cursor at the end of the field, and then hit <control-enter>, a line
feed wil be inserted, even in a date or numeric field. You can scroll between the lines
with the <up> or <down> keys. Try it.

To prevent, u can use an input mask or check the keycode in the KeyDown event.

Grtz,
K

"Marshall Barton" <ma*********@wowway.com> wrote in message
news:pm********************************@4ax.com...
Mark wrote:
Is it possible to enter a line return into any other field other than text (such
as number, currency or date/time)?

You could have just tried it.

Numeric and DateTime fields will not accept a new line.

--
Marsh
MVP [MS Access]

Nov 12 '05 #4

P: n/a
Mark wrote:
I did try it before posting and found what you said.
However, it's important enough that I wanted an
independent confirmation.
I understand.
I assume you regard a currency
field as a numeric field.
Yes
Can you respond to the second question in my post ----
<<How can a user be prevented from entering a line return into a field?>>
Add a validation rule to the table's field:
Not Like "*" & Chr(13) & Chr(10) & "*"
--
Marsh
MVP [MS Access]
Mark wrote:
>Is it possible to enter a line return into any other field other than text
>(such as number, currency or date/time)?


"Marshall Barton" wrote
You could have just tried it.

Numeric and DateTime fields will not accept a new line.

Nov 12 '05 #5

P: n/a
KeejToe wrote:
If you position your cursor at the end of the field, and then hit <control-enter>, a line
feed wil be inserted, even in a date or numeric field. You can scroll between the lines
with the <up> or <down> keys. Try it.

When I try it in A97 and AXP, I can enter <ctrl+enter> on a
numeric or date field but I can not save the record with the
new line in any of those fields.
--
Marsh
MVP [MS Access]
>Is it possible to enter a line return into any other field other than text (such
>as number, currency or date/time)?


"Marshall Barton" wrote
You could have just tried it.

Numeric and DateTime fields will not accept a new line.


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.