The record source is the table. T001_task_table. When the user inputs
data
into the SLD field(text box) it updates the table with the new status
notes.
Below is the code. The SHLD (text box) is a string field to add the
words
"updated and date" showing when the update occured. Cur_stat_info( which
is
a memo field) is the field name in my table.
Thanks for your help.
Private Sub clse_Click()Dim em As String
If IsNull(Me.SUS.Value) Or Me.SUS.Value = " " Then
MsgBox "You must Enter Your Name", vbOKOnly, "Required Data"
Me.SUS.SetFocus
ElseIf IsNull(DLookup("Task_compl_on", "T001_Task_table", "N_task=" & STN)
Then
strcom = "Updated on " & Me.SDT & " " & " " & "- " & Me.SLD & vbCrLf
Me.SHLD = strcom & Me.SHLD
Application.SetOption "Confirm Action Queries", 0
Application.SetOption "Confirm Document Deletions", 0
Application.SetOption "Confirm Record Changes", 0
DoCmd.RunSQL "UPDATE T001_Task_table SET
T001_Task_table.cur_stat_info=SHLD,T001_Task_table.CurStatDte =
SDT,T001_Task_table.who_updtd_task = SUS WHERE [N_task] = STN;"
Application.SetOption "Confirm Action Queries", 1
Application.SetOption "Confirm Document Deletions", 1
Application.SetOption "Confirm Record Changes", 1
em = " Attached please find a snapshot of the completed task" & vbCrLf & _
" This is only a snapshot, you will need to go to:
\\afscvs01\Hqsfs1\Data\fsc\DMC" & vbCrLf & _
" to official close this task. Please press the close button to
official close task."
DoCmd.SendObject acSendReport, "R003_DMC_Com_task", "snapshotformat",
"(e-mail address removed);ronald.cato@ US.army.mil", , "Task
Assignment", em, _
Ken Snell (MVP) said:
Post the SQL statement of the form's Record Source. Identify the field
that
is the memo data type.
--
Ken Snell
<MS ACCESS MVP>
I have a memo field in my table and the user can update this field from
a
form. The problem is that when they input a lot of data at one time,
it
turns the last lines to garbage and/or truncates the last lines.
I would appreicate any suggestions as to why this is happening.
Is there something in the text box property I should set so access
knows
this is a memo field? ( grasping at straws)
Thank you in advance for your help.