Disable a button on last record in a form ?

[ksor]

I have a table with a field containing a path to a file.

When presenting the records in a ongoing form I want a button on each record to open the file.

IF there is a record the SHOULD be a path in the field and the button should then be anabled on every record EXCEPT on the "new record"

I have tried to use the "current" event but it seems like it only fires at the first record !

How can I implement that ?

[AccessPower]

What you are looking for is Conditional Formatting with a textbox that works like a button.

1) Create a textbox that looks like a disabled button
2) Set the textbox to disabled
3) Click on conditional formatting > Choose Expression from the dropdown list
4) In the expression field type [Path]<>""
5) Click on the enabled button as a condition. It's a little button on the right and easy to miss. Also, make the button look like it's enabled through formatting of the background color and forecolor here.

[andy49]

Could you use the form.update event to make the button visible and invisible based on whether there is a value in the form


Sent from my iPhone using Tapatalk

[AccessPower]

It will work, Andy. Even the form_current event works if you click inside of a textbox in any row of the continuous view. Click the row below the one you're in and all buttons will change to enabled or disabled, not just the one for the current record.

[ksor]

Could you use the form.update event to make the button visible and invisible based on whether there is a value in the form


Sent from my iPhone using Tapatalk

That's what I tried but it seems like code for the current event ONLY runs when the form starts filling up with records - NOT when each single record is shown in the form !

I'll try that comditional formatting - I've never used that in Access but a lot in Excel !

[ksor]

What you are looking for is Conditional Formatting with a textbox that works like a button.

1) Create a textbox that looks like a disabled button
2) Set the textbox to disabled
3) Click on conditional formatting > Choose Expression from the dropdown list
4) In the expression field type [Path]<>""
5) Click on the enabled button as a condition. It's a little button on the right and easy to miss. Also, make the button look like it's enabled through formatting of the background color and forecolor here.

Huston we have a problem: Your point 1) - I can't change a textbox to a button - the item in the menu is disabled !

[AccessPower]

Glad we got this one solved together.

[ksor]

Glad we got this one solved together.

Together ? ... I don't think your method will work

[AccessPower]

If you look at my point #1, you'll see that I said to create a textbox that LOOKS LIKE a disabled button.

Here's a sample. It works pretty well.

Continuous Forms Criteria Buttons.zip

[ksor]

If you look at my point #1, you'll see that I said to create a textbox that LOOKS LIKE a disabled button.

Here's a sample. It works pretty well.

Continuous Forms Criteria Buttons.zip

Very sorry - it seems to work well - I just have the field and no "fake button" and it work fine too - thx