Auto-load(?), text box capacity, query conflict...

[FredroStarr]

Hi all, I have three questions to ask, and I'm sure some of you got the answer to it, I would appreciate it a lot.

1) How do I do so when a user opens up database.mdb it automatically loads up the form, without the user clicking the Form tab and opening manually the form...

2) No matter the size of the text box, there seems to be a character capacity by default, how can I increase that capacity...(in forms obviously)

3) when I write in my query a date as yy/mm/dd it chnges to dd/mm/yy when I run the query, why is that and how can I change that? The dates are set by me, by default yy/mm/dd

Thanks in advance!

 

[LonnieJohnson]

1. On the menu bar go to Tools==>Startup===Display Form
Here you can select which form you would like to load when the dB opens.

2. The max number of characters in a text box is 255.

3. In the query grid, are you using...
Format([DateField],"yy/mm/dd&quot

Hope some of this was of help. B-)

ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV

 

[FredroStarr]

Thanks a lot Linnie, but how do i change the character capacity in text box, I know it has to be in properties, but which field...thanks

 

[LonnieJohnson]

This is set in the Table's design view.

B-) ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV