I like the ColumnHistory() feature, but it seems to keep adding to the history even if you don't type anything in.
I think it has something to do with the Nz() part of the standard code, but am unsure exactly. Everytime the form is opened, it creates a new line and I don't want it to create a line unless the post button is hit...
History Text box code is:
Expand|Select|Wrap|Line Numbers
- =ColumnHistory([RecordSource],"Comments","[ID]=" & nz([ID],0))
Expand|Select|Wrap|Line Numbers
- Private Sub Form_Load()
- On Error GoTo Form_Load_Err
- If (Not IsNull(OpenArgs)) Then
- DoCmd.GoToRecord , "", acLast
- End If
- If (Not CurrentProject.IsTrusted) Then
- Exit Sub
- End If
- Comments.Value = " "
- txtComments.Visible = True
- TempVars.Add "NewData", Mid(Nz(OpenArgs), InStr(Nz(OpenArgs), "=") + 1)
- On Error Resume Next
- If (TempVars!NewData <> "") Then
- Title = TempVars!NewData
- End If
- TempVars.Remove "NewData"
- Form_Load_Exit:
- Exit Sub
Also would like it to not say "Version: 6/19/05..." how do i make the word "version" disappear and only the date and time show up?
thanks for your help!
Sophie