View Single Post
  #1 (permalink)  
Old September 20th, 2008, 10:56 AM
dlipkie dlipkie is offline
Registered User
 
Join Date: Jun 2008
Location: , , .
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default Set memo field text format via VBA

I would like to set the text format property of a table field that is dbMemo. Using the GUI I can set "Text Format" to "Rich Text". How do I do this using VBA?

I have no problems creating a dbMemo field.

        Set f = .CreateField("Note_RtMemo", dbMemo)
        ' this fails . no such property
        f.Properties("TextFormat") = "Rich Text"
        ' this fails . no such property
        f.Properties("Text Format") = "Rich Text"
        ' this has compile error
        f.TextFormat
        .Fields.Append f


Reply With Quote