Access keeps rounding numbers

[ZeidHaddad]

Good day to all of you!
I’m having a problem with my Form in which i have a text box in.
This text box contains a percentage and access keeps rounding the number!
For sure my data source is a table and it’s DOUBLE inside the table not an integar . So any idea?

 

[Minty]

Look at the format options for the text box, by default I believe a percentage is set to 0 decimal places?

 

[ZeidHaddad]

I have tried changing the format many times and even i changed it to 2 or 3 decimal places. I don’t care if it’s also showing a percentage sign or not. I only need it to show the number 5,25 instead of 5.

 

[theDBguy]

What does the Format say? Does it say Percent?

 

[ZeidHaddad]

Instead of 4,9% it’s showing 500,000%

 

[theDBguy]

Instead of 4,9% it’s showing 500,000%

No, what exactly does it say in the Format property of the Textbox? It might say General Number or Percent or it may be empty.

 

[ZeidHaddad]

I tested it on general number and Percentage none of that Worked:/

 

[theDBguy]

I tested it on general number and Percentage none of that Worked:/

Hi. I'm asking you what it says now, but you won't answer my question. Have you tried using Fixed?

 

[ZeidHaddad]

Right now it’s fixed my friend.

 

[Gasman]

I happen to have a table in my test DB that is meant to hold percentages for ranges of values.
The field I called Percent, is Number, Single, decimals places Auto.
That holds up to 5 decimal places.
If I create a form based on that table, there is nothing in the format field.
If I make the Format Percentage and then enter 2.75 I get 0.0275 in the table?
If I then make the Format in the table Percentage I get 2.75%

HTH

 

[theDBguy]

Right now it’s fixed my friend.

Hi. Thanks. And does the Decimal property say 2? If so, are you still seeing the number as rounded? If so, what is in the Control Source of the Textbox and can you please post the SQL statement in the Record Source of your form?

 

[ZeidHaddad]

It says 2 and still rounded. The control source for the text box is a table and tbh i don’t how to find the SQL for a table. I thought i can only show it in a query. I’m Not really an expert:/ sorry.

 

[theDBguy]

It says 2 and still rounded. The control source for the text box is a table and tbh i don’t how to find the SQL for a table. I thought i can only show it in a query. I’m Not really an expert:/ sorry.

Hi. Since we are having a hard time picturing what you're seeing/looking at, is it possible for you to post a sample copy of your db with test data?