Creating an Access Form - Would Like a Field that can be formatted like Word

I am creating a transmittal form (input form and associated report) in Access and would like to have a  “Notes” field that can be formatted like word, including cutting and pasting excel tables, images, etc.

The Rich Text html format property allows some formatting but not as much as I would like.
rogerdjrAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
No, remember that I stated :

<In Access 2007 and newer, perhaps you can use an "Attachment field">
...So this will be a field option in an Access Database in the 2007/2010  *Format*.

So are you using an Access 207/2010 formatted DB?
If not, then this will not be an option.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

<<The Rich Text html format property allows some formatting but not as much as I would like.>>

  You won't typically find anything that feature rich in a control for Access.

  I'd add an OLE control and either embed or perferably link to a Word Document.

JimD.
0
 
Jeffrey CoachmanMIS LiasonCommented:
In Access 2007 and newer, perhaps you can use an "Attachment field"

One advantage is that this is specifically designed to support Office Files (Word, Excel, ...etc)
It will also allow you to store multiple attachments for a single record.

<The Rich Text html format property allows some formatting but not as much as I would like.>
Can you be a bit more specific, providing an example?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
rogerdjrAuthor Commented:
couldn't find attachment field as an option in table or form design?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<couldn't find attachment field as an option in table or form design? >>

  It's in table design.  Click the drop down for field type.

JimD.
0
 
rogerdjrAuthor Commented:
I assume you are referring to the "OLE Object?"
0
 
rogerdjrAuthor Commented:
I'm using access 2010, but hadn't re-configured my databace to 2007/2010 format.

That created a whole new problem - this coe is giving me a "data type mismatch" error:

    Dim FilterTxt As String, rst As Recordset, dbs As Database
   
    Dim strSql As String
    Dim ContrId As String
   
    Set dbs = CurrentDb
   
    strSql = "SELECT LkupActItemStatTbl.LkupActItemRecId, LkupActItemStatTbl.Status, LkupActItemStatTbl.OutlkConstVal, "
    strSql = strSql & "LkupActItemStatTbl.LkupOutlkConstOlTaskStatus, LkupActItemStatTbl.ActItemColorCode From LkupActItemStatTbl "
    strSql = strSql & "WHERE (((LkupActItemStatTbl.LkupActItemRecId) = " & Me![CurStat] & ")) ORDER BY LkupActItemStatTbl.Status;"
   
    Set rst = dbs.OpenRecordset(strSql)
0
 
rogerdjrAuthor Commented:
Got the conversion worked out and low and behold the attachment field is there thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.