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

Welcome to P2P. Am I missing something? I don't know about Access 2007 because I don't have it yet, but Access 2003 and before don't allow rich text formatting in memo fields at all. Which version are you using?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division