Changing name of value in value list

[pgseye]

Hi,

I've been asked to continue working on someone else's medical database. I'm just wanting to tidy up a couple of appearance issues on the main layout. There is a field called Eye Disease which sources from a value list (using checkbox) of several eye diseases. One of the values is:

PDF(Prolif Diabetic Retinopathy)

I wanted to change it to:

PDF (Prolif Diabetic Retinopathy)

That is, simply insert a space bewteen the 'F' and the '(' to keep the same spacing with other bracketed values. (I know this is a picky thing, but just wanting consistency).

When I change the value name to this though, the checkboxes are no longer filled. The data hasn't been lost though, because if I change the field to an edit box, the old PDF(Prolif Diabetic Retinopathy) shows up.

Is it just not possible to alter a value name (even by one character) and expect the data to be automatically updated.

(P.S. I'm not needing to create look-ups, portals etc as this is a one off cosmetic fix).

Many thanks.

[Kent Searight]

Just changing an item in a value list will have no effect on the data. The checkbox isn't showing that it's checked because there is no value in the field that matches it anymore. I suggest you do a "Find & Replace" to update the data in your field to the same spelling as in your value list. After the data has been updated, it will show up once again as being checked.

[pgseye]

Many thanks - will give it a go.