Images in cells...

[ewomack]

Hello,

I did a cursory search of the forum and didn't find anything (probably more my search than the content). I also think I know the answer to this, but I want to clear it up once and for all.

Is it true that I cannot insert an image into an Access Table in a way that it treats the image like data (e.g., it comes up on reports as entered).

If so, and I suspect it is so, what would be the best way to associate a row with a certain image in Access? Here's what I'm hoping to do: I have a list of projects and all of them have a status. Right now the "status" column includes the text "Green," "Yellow," or "Red." I would rather have this text display as green, yellow, or red color rather than text. Is this possible?

Thank you!!

 

[wazz]

"Is it true that I cannot insert an image into an Access Table in a way that it treats the image like data?"

not really. http://office.microsoft.com/en-ca/access/HA011472041033.aspx

 

[DCrake]

Simple Software Solutions

If you have a status field that holds the current status of a project why don't you use this info and employ a select case statement to set the Back/Fore colour of a text box to the equivelant color, such as:=

Dim bColour

Select Case fldStatus
Case "Red" : bColour = vbRed
Case "Yellow" : bColour = vbYellow
Case "Green" : bColour = vbGreen
Case Else : bColour = vbBlack
End Select

Me.TxtControl.ForeColor = bColour

CodeMaster:http://www.icraftlimited.co.uk

 

[GaryPanic]

or even the form itself..should be do-able

 

[ewomack]

Excellent! I am able to embed the image in a cell as an OLE Object and the image appears on reports!

The only new problem I have is, if I try to publish it with Word or Excel, the image doesn't show. I've tried playing around with the properties and the form, but with no results. Anything special I need to do with OLE Objects to get them to port to Word?

Thanks for all the help!!