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

  • Thread starter Thread starter ThriftyFinanceGirl
  • Start date Start date
T

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?
 
What is the specific business need which requires you to show which specific
record is being manipulated?
 
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
 
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!
 
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
'====================================================
 
Back
Top