Access keeps rounding numbers (1 Viewer)

ZeidHaddad

Registered User.
Local time
Today, 14:17
Joined
Oct 29, 2019
Messages
44
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

AWF VIP
Local time
Today, 21:17
Joined
Jul 26, 2013
Messages
10,355
Look at the format options for the text box, by default I believe a percentage is set to 0 decimal places?
 

ZeidHaddad

Registered User.
Local time
Today, 14:17
Joined
Oct 29, 2019
Messages
44
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

I’m here to help
Staff member
Local time
Today, 14:17
Joined
Oct 29, 2018
Messages
21,358
What does the Format say? Does it say Percent?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:17
Joined
Oct 29, 2018
Messages
21,358
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

Registered User.
Local time
Today, 14:17
Joined
Oct 29, 2019
Messages
44
I tested it on general number and Percentage none of that Worked:/
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:17
Joined
Oct 29, 2018
Messages
21,358
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?
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:17
Joined
Sep 21, 2011
Messages
14,047
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

I’m here to help
Staff member
Local time
Today, 14:17
Joined
Oct 29, 2018
Messages
21,358
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

Registered User.
Local time
Today, 14:17
Joined
Oct 29, 2019
Messages
44
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

I’m here to help
Staff member
Local time
Today, 14:17
Joined
Oct 29, 2018
Messages
21,358
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?
 

Users who are viewing this thread

Top Bottom