How to make ole object cell on the subform in datasheet view show if its empty or not?

[antodanny]

I have form and a sub form on my ms access which is connected to a sql server (2008 r2).

There's a column called Image (for adding images) in the sub form which is OLE Object type.

My problem is that the image column always shows "OLE object" even if its empty or not.

I want to make it show "Available" if there's a picture in it and if its empty it should show "empty".



I tried going through the property of the image column, may be someone could point me to the right direction of doing this.

[ranman256]

looking at the cell is useless. You view the data in the Ole field by using a form.
THEN you can see if theres data in the field.

[antodanny]

I am viewing the OLE filed in a subform on the main form. The subform is in datasheet view.