D
dhorne
Problem: From Datatsheet view, I want to use the Text Formatting,
Left, Right or Center Justification buttons to change the
justification of all data in the query columns, but these buttons are
grayed out.
I'm new to Access. Are there specific functions I should study to
understand this issue better.
One colleague thought the following issues might be at play.
The columns in question are all expressions that compare values or
numeric fields in other tables and then return a text value ("Y") if
the condition is true. He thought my expression column might be
inheriting the numeric format of the referenced fields, which could
then be preventing my use of text formatting.
The expressions are all similar to this one:
GPA Violation: IIf((([Raw Cum Suspension Data]![Actual GPA])<[Raw Cum
Suspension Data]![Required GPA]),"Y","")
Expression Title: GPA Violation
Logic: if [Actual GPA] < [Required GPA] then return a Y, else return
blank.
Dave
Left, Right or Center Justification buttons to change the
justification of all data in the query columns, but these buttons are
grayed out.
I'm new to Access. Are there specific functions I should study to
understand this issue better.
One colleague thought the following issues might be at play.
The columns in question are all expressions that compare values or
numeric fields in other tables and then return a text value ("Y") if
the condition is true. He thought my expression column might be
inheriting the numeric format of the referenced fields, which could
then be preventing my use of text formatting.
The expressions are all similar to this one:
GPA Violation: IIf((([Raw Cum Suspension Data]![Actual GPA])<[Raw Cum
Suspension Data]![Required GPA]),"Y","")
Expression Title: GPA Violation
Logic: if [Actual GPA] < [Required GPA] then return a Y, else return
blank.
Dave