I've been trying variations of the code posted on this subject in this as well as several other postings without success and have found a caveat (at least in version 10.1) that will keep the format from ever updating.  If you ever had a format in the column entered via the editor and remove it, it doesn't actually remove the format line and always overrides what you do with a blank format.  I had to delete the line from the designer to get it to work.

Example (from designer):

Before: 

ultraGridColumn22.Format = "C2";

After:

ultraGridColumn22.Format = "";

Okay, as long as bPercent is a value based on something in e.Row, then I don't see anything wrong with this code. If you could post a small sample project demonstrating the issue, I would be happy to take a look at it, but otherwise, I don't see any reason why this should not work.

bPercent is set based off a date value on that row. I was setting its value just before the code.

They want all old records to be formatted $ and new records formatted %. I have a record created date in each record.

Sorry I simplified my code because I have to change 4 fields based on this.

I did not get this line included in the example code.

I can mock up  an example but it will work sometimes and seems based off lots of data. When it does not format there is no format at all.  

Hi,

What is bPercent here? It looks like you are using some form-level variable to determine which format to use, but that doesn't make sense. You need to use some information on the row itself. Otherwise, you will be assigning formats to the row pretty much at random.

Hello webd,

I am not able to catch what is happening here so could you please wrap this scenario in a small sample project which reproduces the behavior and attach it here.