Is there no way to mark individual records on a continuous form?

[ThriftyFinanceGirl]

I am working code in the background through a continuous form -- creating
records in another table. What I would like to see is a color formatting for
the background of the record that is currently being manipulated, moving down
the form as the code progresses.

Any suggestions?

 

[Alex Dybenko]

Hi.
you can try to use conditional formatting: add a field to your table which
indicates that record is currently being manipulated, set it before
manipulation, clear after, and base conditional formatting on this field.
also look at
http://www.access-programmers.co.uk/forums/showthread.php?t=63593 or bing
for "highlight current record"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[David H]

What is the specific business need which requires you to show which specific
record is being manipulated?

 

[John Spencer]

Yes.

Here is something posted by Graham Mandeno.

.. Add a small unbound textbox to your form header or footer:
Name: txtCurrentRecord
Visible: No

2. In Form_Current, store the PK value of the current record in this
textbox:
txtCurrentRecord = Me.[PK Field Name]

3. Add a very small unbound textbox to your detail section:
Name: txtHighLight
Enabled: No
Locked: Yes

4. Set the conditional formatting Condition 1 for txtHighLight to:
Expression Is: [txtCurrentRecord] = [PK Field Name]
BackColor: whatever you want for the highlight
You have to set the Enabled property to No in the CF properties. Otherwise CF
is supposed to enable the control.

5. Do Format > Send to back for txtHighlight

6. Add this code to Form_Load:
With txtHighLight
.Top = 0
.Left = 0
.Width = Me.Width
.Height = Me.Section(acDetail).Height
End With

7. Change BackStyle to Transparent for all controls where you want the
highlight to show through.

--
Cheers,
Graham Mandeno

Convoluted, but it seems to work for me. I'm not sure it would highlight a
new record. I haven't tested that yet.

Whether or not this would work with your processing code or not - I don't know
but it might give you ideas on how to handle this.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[ThriftyFinanceGirl]

It has to do with impatiend users.... not any other reason than they want to
be able to see that it is still "working"... I'm sure you had folks like that!

 

[John Spencer]

In that case, I would just open a form and update it as you step through
the records.

Search for Progress bar in the forums.


MVP Sandra Daigle has a nice selection of Progress Bars and forms:


http://www.accessmvp.com/SDaigle/ProgressMeter.ZIP

There is also one at Arvin Meyer's website:

http://www.datastrat.com/Download/ProgressBar2K.zip


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================