Readonly Fields??

[Glenn]

Not sure what is different but some fields that I created are readonly and
some are not.

How can I make a readonly field to be editable?

 

[Jan De Messemaeker]

Hi Glenn,

Since it is not possible to create Readonly fields in Microsoft Project, it
would be nice if you specified the problem in a little more detail.
HTH

 

[Glenn]

Ok. I have 3 fields in a table. They are:

FIELD1 FIELD2 FIELD3

I want to set FIELD1 to be greater than or equal to FIELD2+FIELD3.
If FIELD2 and FIELD3 both are equal to $50 then FIELD1 equals $100.
If I change FIELD1 from $100 to say $80, will Project alert me that
FIELD2 and FIELD3 are too high a value.

This is why I would prefer to have FIELD1 to be readonly. But you
say that readonly cells in Project are not available. Am I missing
the big picture?

 

[Anna]

Glenn,

So..right now you cannot make any change in that field (the one you are
saying is read only) and you want that field to be editable right? In that
case..you need to change the column definition for that particular column.
double click on the title for that column and if the field name in the column
definition window is ID that's why is is read only. You need to change the
field name either to text or number whatever you demand is for that column.
Then you can enter your own data in there.

Hope it helps..

 

[Steve House [MS Project MVP]]

You post is confusing - your are saying you want the field read only but
then you talk about editing it. "Read-only" by definition means you would
never even be ABLE to edit the entry in Field 1 from $100 to $80 in your
example - you simply cannot edit the contents of a read-only field. It
sounds more like you want to validate the entry in Field 1 based on the
contents of Field 2 and Field 3. While there is no direct way to do that,
there's probably an indirect way through the use of VBA. I wonder if it
would be worth the trouble to develop it though. A far easier way would be
to use a 4th field and make it a graphical indicator field that would be
green if F1>=F2+F2 and red if not, alerting you that you need to fix the
problem by hand if the condition is violated.