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

current record with conditional formatting

P: n/a
Hey Folks

I seem to be asking millions of questions. Truth is, I just discovered this
awesome research and having been typing by myself for years the questions
are all coming out.

Here is another favourite:

Can you highlight the current record using conditional formatting.

I saw one solution to this problem by counting all the lines. However, I
need something that does not slow down the application. Conditional
formatting would be perfect if there was a function like CURREC() that was
true if the record was the current record and false if this was not the
case.

Thank you once more

Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create a hidden control bound to the primary key field if you don't already
have one. Now create an unbound, hidden control called something like
txtCurrentKey. In the form's Current event handler, copy the value from the
bound control to the new unbound control. Now, where the 2 values are equal,
that's the current row.

On Thu, 20 May 2004 15:47:34 +1200, "WindAndWaves" <ac****@ngaru.com> wrote:
Hey Folks

I seem to be asking millions of questions. Truth is, I just discovered this
awesome research and having been typing by myself for years the questions
are all coming out.

Here is another favourite:

Can you highlight the current record using conditional formatting.

I saw one solution to this problem by counting all the lines. However, I
need something that does not slow down the application. Conditional
formatting would be perfect if there was a function like CURREC() that was
true if the record was the current record and false if this was not the
case.

Thank you once more

Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.