Notes Field

  • Thread starter Thread starter Ryan Langton
  • Start date Start date
R

Ryan Langton

I have several fields that are very large which I currently have defined as
nvarchar(150).
In my Access .adp I would like to be able to allow carriage returns within
these fields. Currently if you hit [Enter] while editing these fields, the
form goes to the next field rather than inserting a carriage return. The
Access controls I'm using are text boxes. Do I need to use a different data
type? Different controls?

Thanks,
Ryan
 
Use Ctrl-Enter or set the "Enter Key Behavior" for the field to "New Line in
Field" (under the Other tab).
 
Thanks Sylvain!
Is there any way to cause the carriage return in my code? For GotFocus(), I
want the cursor to be placed on a new line and add a timestamp to the field.

Ryan

Sylvain Lafontaine said:
Use Ctrl-Enter or set the "Enter Key Behavior" for the field to "New Line
in Field" (under the Other tab).

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


Ryan Langton said:
I have several fields that are very large which I currently have defined
as nvarchar(150).
In my Access .adp I would like to be able to allow carriage returns
within these fields. Currently if you hit [Enter] while editing these
fields, the form goes to the next field rather than inserting a carriage
return. The Access controls I'm using are text boxes. Do I need to use a
different data type? Different controls?

Thanks,
Ryan
Click to expand...
Click to expand...
 
If (IsNull(Me.t)) Then
Me.t = CStr(Now) + vbCrLf
Else
Me.t = Me.t + vbCrLf + CStr(Now) + vbCrLf
End If

Me.t.SelStart = Len(Me.t.Value)

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


Ryan Langton said:
Thanks Sylvain!
Is there any way to cause the carriage return in my code? For GotFocus(),
I want the cursor to be placed on a new line and add a timestamp to the
field.

Ryan

Sylvain Lafontaine said:
Use Ctrl-Enter or set the "Enter Key Behavior" for the field to "New Line
in Field" (under the Other tab).

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


Ryan Langton said:
I have several fields that are very large which I currently have defined
as nvarchar(150).
In my Access .adp I would like to be able to allow carriage returns
within these fields. Currently if you hit [Enter] while editing these
fields, the form goes to the next field rather than inserting a carriage
return. The Access controls I'm using are text boxes. Do I need to use
a different data type? Different controls?

Thanks,
Ryan
Click to expand...
Click to expand...
Click to expand...
 
Back
Top