By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

How to make it autofill a cell in a table

P: 12
I've attached a picture to aid me in explaining my problem.

attached picture

When making a new row, S3Score automatically has a 0 in it while P1Score doesn't. How do I make it so that P1Score also gets a 0 automatically when I'm creating a new row?

Thank you in advance!
Dec 8 '07 #1
Share this Question
Share on Google+
10 Replies


missinglinq
Expert 2.5K+
P: 3,532
Is P1Score a bound control or a calculated control? What type of datatype is it? How is it populated?

Welcome to TheScripts!

Linq ;0)>
Dec 8 '07 #2

P: 12
Well the way it works is that I have a frame with check boxes in it. When you check a box, it'll fill it with a number. So I'm guessing that is a bound control?
You don't need to press a button for it to be calculated.

Thanks for the welcome.
Dec 9 '07 #3

P: 30
I would recommend first looking at the table design and check to so see if the field's default value is set to 0

I've attached a picture to aid me in explaining my problem.

attached picture

When making a new row, S3Score automatically has a 0 in it while P1Score doesn't. How do I make it so that P1Score also gets a 0 automatically when I'm creating a new row?

Thank you in advance!
Dec 10 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
Which was why I asked if it was bound. Zero is normally set as the default value in a table when a numeric field is created.

Linq ;0)>
Dec 10 '07 #5

NeoPa
Expert Mod 15k+
P: 31,661
Look at the properties of the field that the control (P1Score) is bound to (I'm assuming it's a bound control for now). One of them should be the default value.
Dec 12 '07 #6

P: 12
Thank you missinglinq, HiTechCoach and NeoPa for your help. I was first reading it all and I'm like... I can't get to the properties! Then I re-read HiTechCoach's post which told me to get into the design view. Only After that I understood how to change the properties and set the default value. Now it is working and it looks like my database is slowly taking shape!
Cheers all!
Dec 13 '07 #7

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Dec 13 '07 #8

NeoPa
Expert Mod 15k+
P: 31,661
Good for you HotKgon. Glad you're making progress.
BTW Where does HotKgon come from? It seems a strange kind of name.
Dec 13 '07 #9

P: 12
Good for you HotKgon. Glad you're making progress.
BTW Where does HotKgon come from? It seems a strange kind of name.
Just something I thought up when I was in primary school about 10 years ago. gon for dragon, hot because dragons breathe fire and k for the first letter of my name. As you can see I was a very logical boy when I was a kid ;)
Dec 14 '07 #10

NeoPa
Expert Mod 15k+
P: 31,661
Not a typo of HotKong then (as I'd surmised)?
Logical is good. We like that here ;)
Dec 14 '07 #11

Post your reply

Sign in to post your reply or Sign up for a free account.