rogerdjr
asked on
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.
The Rich Text html format property allows some formatting but not as much as I would like.
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?
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?
ASKER
couldn't find attachment field as an option in table or form design?
<<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.
It's in table design. Click the drop down for field type.
JimD.
ASKER
I assume you are referring to the "OLE Object?"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.LkupAct ItemRecId, LkupActItemStatTbl.Status, LkupActItemStatTbl.OutlkCo nstVal, "
strSql = strSql & "LkupActItemStatTbl.LkupOu tlkConstOl TaskStatus , LkupActItemStatTbl.ActItem ColorCode From LkupActItemStatTbl "
strSql = strSql & "WHERE (((LkupActItemStatTbl.Lkup ActItemRec Id) = " & Me![CurStat] & ")) ORDER BY LkupActItemStatTbl.Status; "
Set rst = dbs.OpenRecordset(strSql)
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.LkupAct
strSql = strSql & "LkupActItemStatTbl.LkupOu
strSql = strSql & "WHERE (((LkupActItemStatTbl.Lkup
Set rst = dbs.OpenRecordset(strSql)
ASKER
Got the conversion worked out and low and behold the attachment field is there thanks
;-)
<<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.