Recent content by Nadalia

FoFa, I opened the form in design mode, clicked on the data field and found "visible" property, but there is only "yes" "no" you can choose, no "false". I tried to set the visible to "no", the field just totally disappeared from the form no matter there is information or not. Any ideas...

Thanks RenAn, it worked like a magic!

I used form wizard to create a data entry form based on a table. The database user wants to print the form that only show the data fields that have information in them. For the data fields that have no information, they dont want them show up on the form at all. How do I set the condition...

ReAn, that is what I mean, merge two text fields into one. I will try what you told. Thank you so much! Nadalia

I work on the database someone else created. Now I want to merge two data fields into one. How do that? Thanks for any help!

thanks! Got it!

One of my data fileds in the database is called "number of items", so I set the data type as number (filed size - Long Integer). But the problem is that when the number exceeds 1000, my user would like to have a comma in between the number, so that it would be much easier for them to read larger...

I have a pull down list from tblType on my frmCPU that I'd like to set a default value. For example, if user want to add information about CPU, my equipment type should be set as "CPU". How to do that? Thanks! Nadalia

I was trying to use outer join to join 4 tables together, so that I can run a keyword search across these tables. The tables that I use to join are: tblMailing (main table), tblSPerson, tblAddress, tblContact. The relationship between tblMailing and tblAddress is one to many, and between...

Wow, I just figured out what causes the problem! Originally, i exported all the records from FileMaker Pro and imported them into MS Access. When exporting from FM, FM always add something in the fields, even though it looked like there is nothing in the field. When I used the records that I...

You're right. I did same thing, and it was trimming down. It is the weirest thing ever in my life. But I have over 4000 records in my database, am I gonna manually do this for all these records?! God, kill me! I appreciate your time, DBL. Have a great rest of the day! Nadalia

Tooooo weird!!!!! Hi DBL and Others, Thank you all for kindly help on this thing. I am still stuck in formatting mailing label layout. These days, I've been playing with Trim function, IIF is null, and some other possible ways, but none of them worked. My mailing labels still looked funny...

Hi HTH, I really appreciate your help. Your method worked beautifully to your attached db, but not to mine. I followed what you suggested: deleted all the textboxes that wizard created, and added unbounded textbox from toolbox, and type all the trim in there, I still got those annoying blank...

Hi, It's you!Thanks for your reply. I put the following in the control source for each address-- =iif ((isnull[Address1]), "", Trim([Address1])) =iif ((isnull[Address2]), "", Trim([Address2])) =iif ((isnull[Address3]), "", Trim([Address3])) But after I click ok, and preview the label, the...

Anybody can help? Please? Thanks in advance! Nadalia