Button image in continuos form

[diegomarino]

Hi,
i have a calendar table in which i have the yes/no field called "completed"



i made a continuos form based on a query of the table "calendar", i'd like to add a button to eery row that changes image if the value is completed or not completed (the "completed" field is either yes or no)

is there any way

[Micron]

Pretty sure this is a property that you cannot set on individual buttons. In a continuous form there is only one of each control but you see many instances of it. Data controls can take on some individual characteristics/formatting, but not embedded pics in buttons. So the short answer would be no.

[diegomarino]

there must be a long answer.
i always find it
stay tuned

[isladogs]

Agree with the short answer given by Micron.
As for the long answer, what you can do is use conditional formatting on each record so, for example, Yes is shown in green and No in red.
Or you can use an IIf expression to display a tick if Completed=Yes and a cross if No. Both can be colour formatted using CF as above

[diegomarino]

I used this trick.
i made a new table with 2 fields, the first is a Yes/no, the second is an attachment.

i used this table in my query and i linked the "completed" field of calendar table to the "yes/no" field in the new table, so it returns a different image if the completed is yes or no.

i enabled the attachment control and i blocked it so when i click on it it doesn't show the small attachment icon used to add the attachment itself.

works greatly

[isladogs]

Congratulations...perhaps you would like to upload an example.
However, wouldn't either of the solutions I suggested have been much simpler?

[diegomarino]

you're right...but i liked the idea of images... pretty beautiful and it's very fast; however, i tried to use your solution but when in "open form" event i tried to use your solution "IIf expression to display a tick if Completed=Yes and a cross if No" it gave me the error "recordset not updatable", and i click on it to start the update query that update to true/false the task
this is the demo

[accesstos]

One more long answer:
(Take a look in the frmCalendar of ButtonImages.accdb in attachment)

[isladogs]

Sorry. Only just had time to look at the test file.
Yes it works but attachments will rapidly 'bloat' database size if you have many records and so are best avoided.
If you really must use an image, I would instead store two small image files in the image library and reuse them repeatedly.

The later example by @accesstos is similar to my suggestion and I prefer that approach
The only thing I not keen on is the default Red x value showing on new records

I've just remembered a thread by CJ_London ag another forum that you may find useful.
https://www.access-programmers.co.uk...eckbox.305659/

[accesstos]

Hi Colin!

The only thing I not keen on is the default Red x value showing on new records

Can be hidden using this expression: =IIf(IsNull([ID]);"";IIf([Completed];"ü";"û"))

Furthermore, we can use html in a Rich Text textbox if need different type of results (symbol/text) in any condition. For example, with an expression like this:

=IIf([Completed];"<FONT face=Wingdings size=6 color=green>ü</font>";"<b>No</b>")

we get a green tick in case of "Completed" and the red word "No" in the opposite case:



Cheers,
John

[isladogs]

Hi John
Yes I've done that myself on several occasions and it works well. In fact it was what I was alluding to in post #4.
Many thanks for going the 'extra mile' and demonstrating it!

[diegomarino]

very nice. Right now i have just two small images but the example is very good, i'll give a look this we

[isladogs]

@diegomarino.
Yes because you only have two records, However, you are adding an attachment for each record.
Even if you keep using the same two images on each record, you will be adding them repeatedly causing file bloat and slowing down your app

[diegomarino]

I used the shortest path...just made a textbox that if the task is completed i see a checkmark, if not completed a "x", and i used a click event to change the status

since those are textboxes the cursor stuck in it, i just solved setting the focus in another control, is there any way to make a textbox behave just like a button?

[accesstos]

Good choice Diego!

You can put a transparent button over the textbox and build your code in button's OnClick event. Set the textbox properties: Locked=Yes, Enabled=No.

Tip: Choosing the "Rich Text way", you avoid the CF and have more freedom about the message to display.

Good luck with your project!

John