Solved

When I open my form it does not display zero,0 on all text boxs

Posted on 2011-03-10
11
243 Views
Last Modified: 2012-05-11
Hi Experts,

I have one form that when I open it it won't display zeros in the text's. as soon as I enter a number into one of the text boxes then they will display 0's and calculate correctly.

All my other forms open and show 0 in the text boxes, I'm not sure why this wont?

Thanks,
patentinv
0
Comment
Question by:patentinv
  • 6
  • 4
11 Comments
 
LVL 5

Assisted Solution

by:kpltechgroup
kpltechgroup earned 150 total points
ID: 35104559
Wrong type of data in them? are they set as numbers in the tables and not as another type of data?

Whats the control source?

More info on how the database is structured... Maybe even upload the file and we could mess around with it and upload it back.

Thanks,
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 350 total points
ID: 35107743
I'd suspect that the form is not opening to a "data entry" sort of mode - that is, your Recordsource or Filter may not be returning records.

Are the textboxes (or the Field to which the TB is bound) setup for a Default value? If not, you could do this in the Design view of the form - select the relevant TB and set a valid default value. this will be prefilled as needed.
0
 

Author Comment

by:patentinv
ID: 35110128
Hello LSM,

The form opens to the correct ID record every time, so I'll try and do kp suggested and check all data types.

Thanks,
patentinv
0
 
LVL 84
ID: 35110575
What do you mean it "opens to the correct ID record?"

If you're opening to EXISTING records, then your viewable data will be determined by whatever is stored in the table. For example, if I have a column named NumHours and I store nothing in it when my record is added (and if there's no Default value specified), then when I view that record, there will be nothing showing on the Form.

Or perhaps I've misunderstood you - if so, and if you can't get it worked out, please provide more details of what you're doing.

0
 

Author Comment

by:patentinv
ID: 35111387
Ok, I have now added default values to each text box but for some reason the form will still not open to the default value, but as soon as I enter a value every text box will show a zero and every thing is correct.

The table shows the zero value, but the query doesn't, the query is bound to the form.

I'm fighting a chest cold which is making it hard to concentrate.

Thanks,
patentinv
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 84
ID: 35111627
< the form will still not open to the default value>

Default values are only important on NEW records. They don't have any impact on existing records.
0
 

Author Comment

by:patentinv
ID: 35111811
Even when I add a new record the default value will not show, do I place the default value in the text box or in the table?

I've placed them in both places, in the table with the the data type of Number and field size double and default value 0, and in the form text box default value 0.

Is this correct?

Thanks
patentinv
0
 
LVL 84
ID: 35111921
You can place them in either place (or both).

Can you post your database?
0
 

Author Comment

by:patentinv
ID: 35112124
I can keep it not showing a default value, but I was really curious why it isn't.

0
 

Author Comment

by:patentinv
ID: 35117533
Hello Experts,

Sorry about the late response I've been a sick and decided to leave the form as it is, until later when I'm feeling a better.

Thanks,
patentinv
0
 

Author Closing Comment

by:patentinv
ID: 35117548
Thanks Experts,

I prefer not to post my apps, even though some times it sure would help!!

Thanks,
patentinv
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DSum for Access 6 47
Create Form using Wizard 14 39
Is it possible to reset DSum? 12 44
How can I name a sub macro so Shift/F10 would work. 3 23
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now