VBA caption button of record

[Ruegen]

Each record has a hidden text box of the date in year format (yyyy)

I want a button on each record (I'm using a continuous form) to show the year

I tried this
Me.text.Caption = Format(Me.Text1, "yyyy")

however that just puts on the one year and not each individual...?

I can't figure out what is wrong. I want 2012, 2013 depending on the record text box.



I'm basically trying to format the caption into year which works but I need it to show the individual record too..

I'm making another form pop up when the date field is selected and they press the year they will be restricted to (yet to figure out).

I know I could add a combobox to a table with the user selecting the year but I'd like them to simply have to make a choice between the available buttons. (I will hide years that are no longer in use).

I'm yet to figure out how to restrict them putting in the date depending on what button they press on the pop of year select form but I figure it is achievable.


Note: I have NO idea how the image capture just duplicated the image in the same one but just ignore that...

[Ruegen]

aaaaand it looks as though that won't work and I will have to make the textboxes into locked buttons ...

http://bytes.com/topic/access/answer...us-forms-again

[Ruegen]

aaaaand it looks as though that won't work and I will have to make the textboxes into locked buttons ...

http://bytes.com/topic/access/answer...us-forms-again

[amrut]

You can change the formatting of textbox to a hyperlink and transperent borders (to look a clickable ) and use the OnClick event

[Missinglinq]

A Command Button is Unbound, and the Formatting of an Unbound Control on one Record is the Formatting of that Unbound Control on all Records! If the Formatting is conditional, depending on another Control on a Record, the Formatting of that Unbound Control on all Records will reflect the condition on the Current Record. Formatting the Textbox to look like a Command Button, and using its OnClick or DoubleClick event, is probably the way to go.

Linq ;0)>