Formatting on one record

  • Thread starter ironwood9 via AccessMonster.com
  • Start date
I

ironwood9 via AccessMonster.com

I could swear I did this once many moons ago, but forgot how to do it - is
there a way to format just one tuple or one row different than the rest in
your table ?
 
J

Jamie Collins

I could swear I did this once many moons ago, but forgot how to do it - is
there a way to format just one tuple or one row different than the rest in
your table ?

What do you mean by format? e.g.

SELECT EmployeeID, FORMAT(BirthDate, IIF(EmployeeID = 1, 'dddd mmm
yyyy', 'yyyy-mm-dd')) AS dob_text
FROM Employees;

but that would beg the question: why change stronly-typed data to text
<g>?

Jamie.

--
 
K

Klatuu

I guess I don't understand, either, Jamie. I thought Tuples were flowers you
tiptoe through <g>
 
P

Pat Hartman \(MVP\)

You can do it by using conditional formatting on a form or report if you are
talking about things like changing the color of the control's background.
 
J

John W. Vinson

I could swear I did this once many moons ago, but forgot how to do it - is
there a way to format just one tuple or one row different than the rest in
your table ?

No.

Tables aren't designed for data presentation and don't allow variable
formatting. Use a Form (for onscreen) or Report (for printing); depending on
your version of Access (2000 or later) you may be able to use Conditional
Formatting to make data-dependent changes in the data's appearance.

John W. Vinson [MVP]
 
I

ironwood9 via AccessMonster.com

OK,

I may be wrong about the usage of the term 'tuple' - that's the last time I
use that - what I was trying to say would be analagous to one Cell in excel
but in an .mdb table - one value for one field - could you have for example
in red font, while everything else was black ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top