datasheet mode - Microsoft Access / VBA

danit58

Is it possible format the backcolor of rows, depending the value in a field
of the the rekords, in datasheet mode??

Can you help me???

Nov 13 '05 #1

Subscribe Post Reply

1946

Stephen Lebans

With A2K or higher you can use Conditional Formatting.
See:
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.
"danit58" <da*****@tiscalinet.it> wrote in message
news:cd**********@lacerta.tiscalinet.it...

Is it possible format the backcolor of rows, depending the value in a field of the the rekords, in datasheet mode??

Can you help me???

Nov 13 '05 #2

dany t58

Thanks!
But, i use access 97 and i think it impossibile.

What do you think about?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #3

Trevor Best

dany t58 wrote:

Thanks!
But, i use access 97 and i think it impossibile.

What do you think about?

http://groups.google.com/groups?hl=e...olsh%404ax.com

(http://tinyurl.com/6sad7)

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

Nov 13 '05 #4

Stephen Lebans

1) Upgrade to A2K or higher
or
2) Switch from Datasheet to Continuous View
or
3) Forget it!

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"dany t58" <da*****@tiscalinet.it> wrote in message
news:41**********************@news.newsgroups.ws.. .

Thanks!
But, i use access 97 and i think it impossibile.

What do you think about?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #5

Similar topics

Field Names in Datasheet View - A97

by: Keith Wilby | last post by:

I have a form which allows both form and datasheet views. My question is, is it possible to control the field (column) names in datasheet view? What happens at the moment is that the name is...

Microsoft Access / VBA

combo box name property in datasheet view issue

by: Kent Eilers | last post by:

I want to follow naming conventions for my controls - i usually prefix combo boxes with "cbo". When a form is in datasheet view however i do not want the user to see the 'cbo' prefix in front of...

Microsoft Access / VBA

Form created as datasheet; displays as single form

by: RLN | last post by:

Re: Access 2000 I have a form (Form1) where the default view in the properties is set to "Datasheet". When I click on the Form1 object from the container to display it, it displays fine in...

Microsoft Access / VBA

Help Displaying Tables in DataSheet Format

by: Aladdin | last post by:

I have an MS Access form on which I have a listbox listing tables in that database. I want to be able to click on any of those tables and view its contents on the same form using subforms or any...

Microsoft Access / VBA

how to force form to load in datasheet view

by: Danny | last post by:

I am using a switchboard to load a form that I would like to display in datasheet view or table view. But it does not go into that mode when using the switchboard wizard to launche the form. is...

Microsoft Access / VBA

Datasheet form - change column width, with a twist!

by: Arnie | last post by:

I have searched this NG for datasheet column width posts and have read many of them. None of them seem to address what I would like to do. I'm beginning to think what I want can't be done. Here...

Microsoft Access / VBA

Datasheet to Open Child Form

by: BASSPU03 | last post by:

(I'm using Access 2003 on a Windows XP O/S.) I've gotta present an update on my database this week--possibly within the next 24 hours. A solution or guidance to this inquiry would really, really...

Microsoft Access / VBA

Datasheet Form insists on showing in Form view.

by: Ericks | last post by:

I have a sub Form that is in Datasheet mode. On my Main form I have a button that opens this form but then it shows in Form view. I set both the Default view and Allowed view options to Datasheet but...

Microsoft Access / VBA

Restore size Datasheet View Form on top of Maximized Form

by: Alan Forsyth | last post by:

That rather long subject says it. In Access97 running on XP - I want to display a Maximized size Form01, then open a Restore size Datasheet View Form02 on top of the first Form. PopUp won't give...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing