Need to modify cell data without overwriting

[damarious]

OK, you guys helped me with one, lets see if you can walk me through this:

Access 2000:
I need to pull the data from a cell, put it in a variable, do some stuff to the variable, then put it back in the cell (all text data).

Where do I start?
And I can do the stuff and put it back, I just can't get it out.

[Clunietp]

what "cell" are you referring to? Are you talking about a cell in a grid control, or maybe the value of a field in a record?

[damarious]

Sorry, I'll clarify:
MS Access 2000 database. I have a table looking like this:

cnum | cname | IPs | notes

I need to read the IPs information from a record with cnum X, append data to the info and place it back in the table.

All fields are strings.