Question Textbox Formating

[staylor]

Hi all,

I got another queston for you gurus out there. I have a field in a table that populates from a calculated textbox in a table. The data is displayed in the textbox with the "fixed" format, but fills the table with the full value.

I want to have the same "fixed" format displayed for the report, but when I make the table format "Number,Fixed", it rounds to the nearest whole number with ".00" for the places after the decimal point.

Is there any way to force the formating I want?

 

[KenHigg]

a. Can you simply set your data type in the table to integer?
b. The part where you say you calculate the value leads me to think you need not store the value in the first place but rather 'calculate' it where ever need it.

 

[staylor]

I've tried everything under "Number", it always rounds to the nearest whole number.
I'm guessing i have to write some formating VB coding, eh.

I store data is for a temp report, I couldn't figure out another way to save calulated values that change with every record entry, other than a temp table.

 

[KenHigg]

You said it stores to the table with full value which is what I assumed you did not want - ? So do you want to store just the integer (no decimals) or do you want the decimal part of the number to be maintained in the field?

 

[staylor]

yes i want to display the "fixed" format , which is integer + 2 decimals. But when i select any of the number formats, it rounds to the nearest whole number.

Everything I've tried does something like this 45.8348738 turns into 46.00 or 46. I want it to be 45.83.

 

[KenHigg]

Hate to bug out but its quitting time - Maybe someone else can jump in and help -

 

[staylor]

Same here

Hate to bug out but its quitting time - Maybe someone else can jump in and help -

Same thing here, Weekend calls. Will continue monday.

 

[staylor]

Any more thoughts on my formatting problem?

 

[staylor]

Solved my own problem....LOL. I set table format as follows...

Format>Number
Data Size>Decimal
Scale>2
Decimal Places>2

Works fine like this


Sorted, you may lock