Recent content by Cosette

Thank you I will try.

Hi all, I have a form that records a student being late. The form opens to a new record, and then the student ID is selected from a combo box. The receptionist then enter a reason in a text field box. After that, I have a button that triggers a report for that student that he can take to...

OK Duane, I think there is a major misunderstanding from my first thread here. My only goal was to remove the space between two controls. You wrote: 2) Do you understand vertical spacing between the bottom of one control and the top of another will never shrink? If that is the case, I can...

Duane, Thank you for all your work on this issue. However, I did what you said and the Detail section does not shrink when there is no data in the field. I have tried other fields and I get the same problem. Even though it is the last field in the detail section and both the are set to can...

Duane, Thank you for your help. There is no border if the value is null. The control source of the text box is =[tblSpouse.FirstName] & " " & [tblSpouse.LastName] I did what you told me and the text box does return "it's really null when there is no spouse in the record and "it ain't null...

Duane, By display I guess you meant to give the border an actual thickness, which I did. The text box only appears when there is a name inside it, and the border is thick, but when null, it doesn't shrink. Sorry, I don't know what I am doing wrong. I set the event for 'on Format'. Could that...

Hi Duane and Larry, Larry thanks for the advice, I will try it if I can't troubleshoot the existing reply from Duane. Duane, what I meant is that I created the detail section with 'txtmember' and 1 inch below 'txtspouse'. That way, I could test if, when spouse is empty, the next name appears...

Hi Dhookhom, I did that already to no avail. If I leave an extra 1 inch of blank in the detail section, it doesn't shrink, even when I select can shrink for both the text box and the detail section! Thanks for any other idea you may have. Cosette

Hi all, I have a detail section that lists members and spouses on the row below if there is a spouse in the record set. I have an 'on format' trigger that makes txtspouse not visible if the value is null. So far so good. Unfortunately, even though I have allowed the detail section to shrink...

Thank you, Requerying on update was the key.

Hi all, I have a form that writes to a table. Depending on the value I select in a combo box, a few dlookup values get generated in other controls. Unfortunately, the values are displayed only after the record is saved by going to a new record and going back to the previous record...

I know that I am dumb, but I guess I am THAT dumb! Here is something that always bothered me. I want the value that the Dlookup function locates to be stored in the field Fuel Surcharge. If I make the control Source =Dlookup(....), the text box becomes unbound. How do I bound the text box to...

Hi Aceman, Thanks for the suggestion. Tell me though, when I update the percentage on a weekly basis, won't all the recorded history chage as well to reflect the new % ? Thanks Cosette

Remou, Thanks for the reply. That makes a lot of sense - Dlookup will have to do. Thanks

Hi all, I am stumped. I can't find where to tell access to put the query name, address and page numbers. Two computers show it, and two others don't! I went to options and the options are all the same. Thanks for the help. Cosette