Hi Al,
My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.
Datasheets are quite limited in what you can access and change on a "per
record" or "per field" basis. However, you can work around it with what I
call a pseudo datasheet. This is actually a form designed to look like a
datasheet and run in 'continuous form" view.
1-Create a form with a form header.
2-Place labels in the form header to represent column headings.
3-Place your textboxes in the detail section (without labels), immediately
under the form header bar.
4-Size your textboxes the width you want your columns.
5-Shrink your design area in the detail section so that it is only the
height of the row of textboxes.
Now each textbox's properties are available for change/modification.
Remember, if you are using Access 2000 and above, you can conditionally
format each of these controls so that the textbox properties (font color as
an example) will change with each record. If you are using Access 97 and
below, you do not have this option and a change made on one record will be
reflected for all displayed records.
I hope this helps! If you have additional questions on this topic, please
reply to this posting.
Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
Regards,
Dennis Schmidt
Microsoft Support
