By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,567 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,567 IT Pros & Developers. It's quick & easy.

Display text field for current record only......

P: n/a
Hi,

I have a continuous form.
For each record I have a field 'HeldDate' (Text Field from a table)
Against each record I have a button which sets the visibility of this
text box to 'True' and does various other actions.

Is it possible to display the text box just for the current record,
rather than it displaying for all following records at the same time,
i.e. set visibility to true where record id - xxx

Appreciate your help

David

Dec 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You cannot show/hide textboxes on a row-by-row basis in a continuous form.

In Access 2000 and later, you can fudge the effect with Conditional
Formatting, as demonstrated here:
http://www.lebans.com/conditionalformatting.htm

Another option might be to move the control into the Form Footer section,
and the entry for the current row will show there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <go********@googlemail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I have a continuous form.
For each record I have a field 'HeldDate' (Text Field from a table)
Against each record I have a button which sets the visibility of this
text box to 'True' and does various other actions.

Is it possible to display the text box just for the current record,
rather than it displaying for all following records at the same time,
i.e. set visibility to true where record id - xxx

Appreciate your help

David

Dec 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.