Grid View?

[Guest]

Not sure if that's the correct word choice, but we are veveloping a checkbook
application and would like to have hte register display check entries in
alternating colors--similiar to QB and Money. Which add-in or tool do we use
to display information if this manner? Also, would need to be able to use a
drop-down in the payees line or the account-paid line so the user can change
the account listed.

 

[Douglas J. Steele]

You should be able to use conditional formatting to get the alternating
colours.

To get the drop-down, simply use combo boxes.

 

[Stephen Lebans]

See:
http://www.lebans.com/alternatecolordetailsection.htm
AlternateColorDetailSection.zip is a class to allow for alternate bands of
color for Forms in Continuous View.

or

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.

 

[Albert D.Kallal]

You can get some ideas here as to how you display data.

If you look at the last screen shot,..you will see a screen that breaks out
funds from a cheque to different accounts. This is a "classic" business
problem, and ms-access handles this REALLY well if you place two sub-forms
on a main form.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm