Line Return

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

Mark wrote:
[color=blue]
>Is it possible to enter a line return into any other field other than text (such
>as number, currency or date/time)?[/color]


You could have just tried it.

Numeric and DateTime fields will not accept a new line.

--
Marsh
MVP [MS Access]

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" <marshbarton@wowway.com> wrote in message
news:pmgsuvsqlnh239mgd475p2j8t4eongc6t2@4ax.com...[color=blue]
> Mark wrote:
>[color=green]
> >Is it possible to enter a line return into any other field other than text[/color][/color]
(such[color=blue][color=green]
> >as number, currency or date/time)?[/color]
>
>
> You could have just tried it.
>
> Numeric and DateTime fields will not accept a new line.
>
> --
> Marsh
> MVP [MS Access][/color]

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" <marshbarton@wowway.com> wrote in message
news:pmgsuvsqlnh239mgd475p2j8t4eongc6t2@4ax.com...[color=blue]
> Mark wrote:
>[color=green]
> >Is it possible to enter a line return into any other field other than text (such
> >as number, currency or date/time)?[/color]
>
>
> You could have just tried it.
>
> Numeric and DateTime fields will not accept a new line.
>
> --
> Marsh
> MVP [MS Access][/color]

Mark wrote:[color=blue]
>I did try it before posting and found what you said.
>However, it's important enough that I wanted an
>independent confirmation.[/color]

I understand.
[color=blue]
>I assume you regard a currency
>field as a numeric field.[/color]

Yes
[color=blue]
>Can you respond to the second question in my post ----
><<How can a user be prevented from entering a line return into a field?>>[/color]

Add a validation rule to the table's field:
Not Like "*" & Chr(13) & Chr(10) & "*"
--
Marsh
MVP [MS Access]


[color=blue]
>[color=green]
>> Mark wrote:
>>[color=darkred]
>> >Is it possible to enter a line return into any other field other than text
>> >(such as number, currency or date/time)?[/color]
>>
>>[/color]
>"Marshall Barton" wrote[color=green]
>> You could have just tried it.
>>
>> Numeric and DateTime fields will not accept a new line.[/color][/color]

KeejToe wrote:
[color=blue]
>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.[/color]


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]


[color=blue][color=green][color=darkred]
>> >Is it possible to enter a line return into any other field other than text (such
>> >as number, currency or date/time)?[/color]
>>
>>[/color]
>"Marshall Barton" wrote[color=green]
>> You could have just tried it.
>>
>> Numeric and DateTime fields will not accept a new line.[/color][/color]