How to format DBTextEdit (float field) as a percent?
Posted on 2009-12-21
I have a data entry form that has a DBTextEdit field pulling in a float but when I show the form, it needs to show as a percentage. I have this same field in a grid and the procedure I have is the following:
if (AText <> NULL) OR (AText <> '') then begin
AText := FloatToStr(StrToFloatDef(AText,0) * 100);
AText := AText + '%';
I tried this in both the OnValidate and OnNewLookupDisplayText and those did not work... any ideas how to accomplish this? I'm sure it will be simple and I am just overlooking something really silly... thanks for your help!