Line Return

[Mark]

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

[Marshall Barton]

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]

[Mark]

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]

[KeejToe]

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]

[Marshall Barton]

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.

[Marshall Barton]

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.