Prev: how can i play a 'wav' file in access 2007
Next: Command BUtton Caption on continuous forms
From: Arvin Meyer [MVP] on 5 Jul 2008 09:40
If you want to handle it that way, you will need to bind the caption text to
the textbox (a relatively easy task if your recordsource is a query), then
place a Transparent button over the textbox. Command buttons have a
transparent property, which can be set on the Format tab of the Property
Sheet.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Dhonan" <Dhonan(a)discussions.microsoft.com> wrote in message
news:D870A882-6DCF-4BBF-AAFD-D38C96104086(a)microsoft.com...
> You may be right. The only way I have been able to partially do this is
> to
> create a text box that has logic to display what I want the caption to say
> and then place it over the top of the command button. Then sent the
> on-click
> event for both the text box and command click to the same thing. But this
> is
> a little clugy and the pointer doesn't display when the mouse is moved
> over
> the text box (even though the click still works)
>
> "Arvin Meyer [MVP]" wrote:
>
>> I don't think that's possible in a continuous form. You could place the
>> button in the form's header or footer and run your code in the form's
>> Current event.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>> "Dhonan" <Dhonan(a)discussions.microsoft.com> wrote in message
>> news:566226C8-7866-49B0-A8C4-783652D74CC7(a)microsoft.com...
>> >I have a continuos form with a command button that I would like the
>> >caption
>> > of that command button to change depending on the transaction type of
>> > the
>> > record.
>> >
>> > For example, if the first record displayed is transaction type "123"
>> > then
>> > the caption should be "display report for trans 123".
>> >
>> > If the second record is transaction type "456", then the caption should
>> > read
>> > "update trans 456".
>> >
>> > I have tried using "on current", but that changes the caption on every
>> > button on every line.
>> >
>> > Any help would be appreciated it.
>> >
>> > Thanks
>>
>>
>>


First  |  Prev  | 
Pages: 1 2
Prev: how can i play a 'wav' file in access 2007
Next: Command BUtton Caption on continuous forms