set all number fields to 2 decimal places

Hi,
I have a database with 20 Number fields (20 columns of number data). Is there a way to set all Number fields to display two decimal places without going through each and every field property box and changing the decimal field from "Auto" to "2"?

Jan 24 '13 #1

Subscribe Post Reply

1375

Rabbit

12,516

Expert Mod 8TB

You'll have to set it on each field.

Jan 24 '13 #2

Annerb

Ahhhh ok. Perhaps I should send a suggestion to MS to include that option in the next version of Access... :)
Thanks!

Jan 24 '13 #3

NeoPa

32,556

Expert Mod 16PB

It's possible to do Anne, but would involve complicated code. from how your question is posed I would guess you're looking for something simpler (That, and the effort involved would require many more than 20 fields to make it remotely worthwhile).

If you're still keen, and prepared to get into a fair bit of work on the project, I can take you further.

Jan 24 '13 #4

by: John Bentley | last post by:

John Bentley writes at this level: If we think about our savings accounts then division never comes in (as far as I can see). We deposit and withdraw exact amounts most of the time. Occasionaly...

.NET Framework

number of decimal places

by: shez | last post by:

Hi, Is there any way to output a double value with different number of decimal places (apart from using 'sprintf'). I looked up the reference for C++ streams and found the 'setprecision'...

C / C++

How to tell if a number has decimal places different than 0

by: Gaijinco | last post by:

Sooner or later everytime I found recreational programming challenges I stumble with how I test if a number is has decimal places differnt than 0? For example if I want to know if a number is a...

C / C++

Double data type count number of decimal places?

by: android | last post by:

I require a function that takes a double as a parameter and returns the number of decimal places. What is the most efficient way in c# to find out the number of decimal places I have written a...

C# / C Sharp

Formatting numbers with a given number of decimal places

by: scan87 | last post by:

Can somone please, please give me the solution for the following problem. I need to submit it on Monday. Write a global function called format, which formats numbers with a given number of decimal...

C / C++

Find out number of decimal places

by: mattlightbourn | last post by:

Hi, I hope you're all well. I need to right justify some figures in a list box and the only way I seem to be able to do it is by using the number as text and doing something like this in a...

Microsoft Access / VBA

Concatenate Numbers And a String with A defined Number of Decimal places

by: TSGB | last post by:

Hi, I have a Table which has 2 Double, Fixed Number fields to 3 decimal places. This fields are populated as the result of 2 division operations which lead to multiple decimals (the numbers...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

set all number fields to 2 decimal places

Similar topics