Terima Kasih Mas Erwin, Sudah berhasil. sukarno ----- Original Message ----- From: Erwin Sugiawan To: [email protected] Sent: Tuesday, August 07, 2007 1:19 PM Subject: Re: mau cara gampang Re: [belajar-access] Format Condition
** kriteria nya ==> kalo receivedfrompe sudah ter isi maka ==> sending number berwarna hijau. mas, saya buka clue nya ........ untuk mengetahui sebuah field sudah ter isi atau belum , kalo saya mempergunakan Is Not Null atau gunakan IS NULL jadi untuk masalah di bawah, syntax nya menjadi [receivedfrompe] Is Not Null maka bla bal bla Best regard Erwin Sugiawan ----- Original Message ---- From: sukarno <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, August 7, 2007 11:34:40 AM Subject: Re: mau cara gampang Re: [belajar-access] Format Condition Belum mengerti. text1=sendingnumber text2=receivedfrompe keterangan: kalau receivedfrompe sudah terisi tanggal maka sending number berwarna hijau. Bentuk Form Tabular. terima kasih. sukarno ----- Original Message ----- From: Erwin Sugiawan To: [email protected] Sent: Friday, August 03, 2007 5:45 PM Subject: Re: mau cara gampang Re: [belajar-access] Format Condition "BuySell" merupakan nama field , di dalam format conditional namafield diawali dgn tanda [ dan di akhiri dgn tanda ] . "Buy" atau "Sell" merupakan nilai dari field BuySell, krn isi dari field BuySell merupakan text ,maka diawali dgn tanda " dan di akhir dgn tanda " bila Field buysell merupakan numerik, tidak di butuhkan tanda awal dan akhir. kalo ini masih belum jelas....... ......... ......... ......... ......... boleh kok tanya-tanya lagi, masih gratis kok heheheheheh Best regard Erwin Sugiawan ----- Original Message ---- From: sukarno <designj-sik@ gr.sei.co. jp> To: belajar-access@ yahoogroups. com Sent: Friday, August 3, 2007 4:54:07 PM Subject: Re: mau cara gampang Re: [belajar-access] Format Condition Maaf ga ngerti. [Buysell]="Buy" [BuySell]="Sell" apa maksudnya ya??? ----- Original Message ----- From: Erwin Sugiawan To: belajar-access@ yahoogroups. com Sent: Friday, August 03, 2007 4:27 PM Subject: mau cara gampang Re: [belajar-access] Format Condition mau cara gampang, ngak pake coding...... ..... tp jgn bilang ke siapa2 ya... :) 1. klik text yang mau di buatkan format conditional 2. klik format - conditioning format 3. conditional 1 ==> expression is [BuySell]="Buy" pilih warna yg di inginkan 3. conditional 1 ==> expression is [BuySell]="Sell" pilih warna yg di inginkan Best regard Erwin Sugiawan ----- Original Message ---- From: Sofyan Efendi <[EMAIL PROTECTED] cc> To: belajar-access@ yahoogroups. com Sent: Friday, August 3, 2007 4:07:09 PM Subject: Re: [belajar-access] Format Condition maap, repisi: Private Sub Form_Current( ) If IsNull(Me!text1) = False Then Me!text2.BackColor = 32768 else Me!text2.BackColor = 16777215 end if End Sub ----- Original Message ----- From: Sofyan Efendi To: belajar-access@ yahoogroups. com Sent: Friday, August 03, 2007 4:03 PM Subject: Re: [belajar-access] Format Condition goto vba: Private Sub Form_Current( ) If IsNull(Me!text1) = False Then Me!text2.BackColor = 32768 End Sub ----- Original Message ----- From: sukarno To: belajar-access@ yahoogroups. com Sent: Friday, August 03, 2007 3:46 PM Subject: [belajar-access] Format Condition Master Acces, Mohon bantuan, Saya ingin memberi warna pada suatu textbox dalam form dengan format condition. misal : Jika Text1 ada isinya, maka text2 warna baground menjadi hijau. Terima kasih. sukarno -------------------------------------------------------------------------- Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. ---------------------------------------------------------------------------- Pinpoint customers who are looking for what you sell. ------------------------------------------------------------------------------ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
