Highlighting current record problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Contunuous form displaying 20 rows but which also has the current
row record contents displayed in unbound columns above. This allows the User
to change any of a number of the unbound columns to see the outcome of the
changes. When happy the User confirms the changes and the unbound data is
then used to update the relevant data record.

Problem is :-

Highlight current row in continuous area of form whilst changing data in
unbound columns, so that user can see the original data.

Ideas anyone?
 
That's way above my understanding of Access, is there nothing simple/quick
and dirty available?
 
Hi Arvin,
actually the relevant solution is here:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet View

Version 2.7

Added sample demonstrating how to achieve a background Hover/Highlighting of
rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based on a
Boolean(Yes/No) field.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Ace,

You should avoid conditional formatting if possible. Solutions involving it come with their own problems - jittery display -
sometimes changes to usual order of events, which can have other effects.

Did you know that you can have two bound forms editting the same recordset? When you do, they move the current record in sync and
the user can edit through either one, and 'everything works'. If I understand your need, this might be a way to go. If you create
a form with two subform controls (say, .subform1 and .subform2) holding two different forms (which must have a common recordsource),
but one having 'datasheet' as its default view, the other with 'single form', then you get a list of records in the datasheet view
and a single record in the form view.

Now all you have to do is contrive to sync them up, like this:

Private Sub Form_Load()
With Me
Set .subform1.Form.Recordset = .subform2.Form.Recordset
End With
End Sub

If you only want edits to be applied in the form view, then set your form properties appropriately. In your case, it sounds like
you don't want editting in the datasheet view, but want to allow edits in the form view.

Hope this helps....

If it doesn't and your still looking for a solution, explain again/better what you';re trying to do....

Cheers,

--
Malcolm Cook
Stowers Institute for Medical Research - Kansas City, MO USA
 
Back
Top