Vis / Skjul kommandoknap afhængig af indhold af felt

Cant youalredaysee the memo field on the form, if so what is the button supposed to do?

youalredaysee = you already see

Hi Terry
The memo field can contain quite a big amount of text, so I choose
not to show it to keep my form nice and neat. Sometimes the memo
field is blank which is why I want to show or hide a button/link that
show a new form with the memo field.

Maybe you have a better idea?

Thx for helping out.
Sup

The problem with trying to hide a button on a continuous form is that when you hide on then they all (all records) get hidden.

What you could do was maybe show only the first 20 or so characters and then if the user double clicks on the field, open another form (dialog) where you show the whole text if there is any.

Is it possible to make a condition for a button.

Something like:
IF(memofield <> NULL)then show button
Else
Hide the button.

Or maybe enable/disable the button depending on the condition.

You can try this in the forms on current event

If Len(memofield) = 0 Then
Me.YourButtonName.enabled = False
else
Me.YourButtonName.enabled = TRue

end if

But you will see that it effects ALL buttons

Hi again terry
Thx for responding so quick.
Im a little new to Access, so im not sure where to put the code.
Where can I find "on current event" in my form?

you need to open the properties for the form and the press the event tab.

Hey terry
You're the man. It worked with a little tweak.
Merry xmas and kind regards
Sup

Great, does it disable the others also?

and a Merry Xmas to you too.

Hey again mr.t :)
I have a few other buttons on the form but they
dont seem to be affected.

I was thinking since each button has a unique name
the "YourButtonName" would only be affected. Does
that sound right to you?

After playing around I was thinking about using
faneblade(dont know the english name, tabs maybe)
for the memo fields I have. It would be more user
friendly I think.

But since im pretty new to Access im probably going
to ask for some more help sometime soon :)

Thx once again.
Sup

If it isnt a continuous form (more than one record in list) then it wont effect the other buttons (with other names).

Yes, a tab control might be an idea.

See you around :o)