Results 1 to 3 of 3

Thread: Text format

  1. #1
    Join Date
    Jan 2015
    Posts
    23

    Post Unanswered: Text format

    Good day, pls I hav e two forms sending data to thesame table, one for general and the other for admin. I have also added line break with ur help (vbcrlf). Is is there a way I can differenciate the data from admin and other with alignment, color, italic etc as part of the codes. The code is similar to:

    Code:
    Private Sub Confirm_Click()
    'This line checks to assure that the TempNotes field is not empty. If it ' is empty nothing happens (this prevents just the date from being added)
    If Not IsNull(Me.TempNotes) And Me.TempNotes <> "" Then

    'This checks if ClientNotes is empty and if so simply adds the
    ' date and TempNotes to ClientNotes
    If IsNull(Me.ClientNotes) Or Me.ClientNotes = "" Then
    Me.ClientNotes = Now & ": " & Me.TempNotes
    'This line blanks out the TempNotes
    Me.TempNotes = ""
    Else 'If there's already data in ClientNotes this adds the new notes
    ' to the old
    Me.ClientNotes = Me.ClientNotes & " " & Now & ": " &
    Me.TempNotes
    'This line blanks out the TempNotes
    Me.TempNotes = ""
    End If
    End If
    End Sub

    I tried alignment, color etc on both the TempNote and ClientNote but it affects data fron both sides. Maybe something can be done on the code side.
    Assistance will be appreciated thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I don't think you can. you may be able to using a RTF (Rich Text Format) control assuming your version of Access permits it.

    As said before I think the better way of designing this is to use a sub stable to hold the comments, one row per comment. you could add the userid (taken from the network API call, not the horrible environ variable, An dif you wanted to the computer that posted the message as well (again an API call).
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2015
    Posts
    23
    Thanks, let me try the rich text format. I will get back to u.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •