fields visible in design view not visible in form view

[TENGEO]

This is very frustrating and I hope ANYONE can PLEASE tell me whats going on.

I have a form that "looks" fine in design mode but in form mode none of the field's are visible. I can see text typed in the header and footer with no problem, but the detail section of the form is one solid color as if no fields are present.

Of course, when I switch back to design mode I can see the fields just fine, I have ruled out the obvious like whether the fields are set to visible in properties and whether the fill collor is the same as the background .. but that still would not explain (if i had not done that) why i cannot see any fields, text, or basically anything in the detail section of the form.

PLEASE HELP!!!

 

[fernin8r]

Sometimes fields become invisible when there is a null value or some sort of calculation error. I would make sure that, either there are no null values or try using the Nz function. hope that helps

 

[TENGEO]

no data

there is no data in the database yet, so there should be no null values

 

[RichMorrison]

Well..........
if the form is continuous and the RecordSource is empty
then the detail section will appear as a solid color.

RichM

 

[TENGEO]

that must be it!

doh!


i work in cold fusion and (ah hell let me stop trying to explain I SIMPLY DID NOT KNOW THAT!!) this is the first time i have done a form in Access before the database had any data in it .... ok another question .. how would you enter data into a new database via a form .. if the datase is empty

a better way to state it is: can I make a form that has no data visible in form view? (you mentioned something about continuious form) no one form will have more that say.... hmm .... amout 12-15 fields on it .. so there will be no need to scroll or anything (i don't know what continuous means as you have probalby guessed)

KEEP THE HELP COMING . thank you in advance!

 

[fernin8r]

I wonder. if you go to a new record the text boxes should reappear. if this is true.

use the goto function on the OnOpen property of the form.

DoCmd.GoToRecord,,,,acNewRec. (unsure about the # of commas)